GEOMEANX Function (DAX)
|
Returns the geometric mean of an expression evaluated for each row in a table.
To return the geometric mean of the numbers in a column, use GEOMEAN Function (DAX).
GEOMEANX(<table>, <expression>)
Parameters
| Term | Definition |
|---|---|
| table | The table containing the rows for which the expression will be evaluated. |
| expression | The expression to be evaluated for each row of the table. |
A decimal number.
The GEOMEANX function takes as its first argument a table, or an expression that returns a table. The second argument is a column that contains the numbers for which you want to compute the geometric mean, or an expression that evaluates to a column.
Only the numbers in the column are counted. Blanks, logical values, and text are ignored.
The following computes the geometric mean of the ReturnPct column in the Investments table:
=GEOMEANX( Investments, Investments[ReturnPct] + 1 )