DAX Statistical - GEOMEAN function
Advertisements
Description
Returns the geometric mean of the numbers in a column. DAX GEOMEAN function is new in Excel 2016.
Syntax
GEOMEAN (<column>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 | column The column that contains the numbers for which the geometric mean is to be computed. |
Return Value
A decimal number.
Remarks
Only the numbers in the column are considered.
Blanks, logical values, and text are ignored.
Example
= GEOMEAN (Sales[Sales Amount])
dax_functions_statistical.htm
Advertisements