GEOMEAN DAX Function (Statistical)
Returns geometric mean of given column reference.
Syntax
Parameter | Attributes | Description |
---|---|---|
ColumnName |
Column that contains values for geometric mean. |
Return values
Return a decimal number with the geometric mean.
Remarks
The GEOMEAN function internally executes GEOMEANX, without any performance difference.
The following GEOMEAN call:
GEOMEAN ( table[column] )
corresponds to the following GEOMEANX call:
GEOMEANX ( table, table[column] )
Examples
-- GEOMEAN computes the geometric mean of the values in a column. -- GEOMEAN is the short version of GEOMEANX, when used with one -- column only. DEFINE TABLE SampleData = { 2, 4, 4, 4, 5, 5, 7, 9 } EVALUATE { ( "Average", AVERAGE ( SampleData[Value] ) ), ( "Geometric Mean", GEOMEAN ( SampleData[Value] ) ) }
Value1 | Value2 |
---|---|
Average | 5.00 |
Geometric Mean | 4.60 |
Related functions
Other related functions are:
Last update: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/geomean-function-dax