The GEOMEAN function returns the geometric mean of the numbers in a column.
Syntax
GEOMEAN(
column
)
Parameters
- column: Column containing the numbers whose geometric mean is to be obtained.
Returned value
The GEOMEAN function returns a real number.
Additional Information
The function only considers the numbers contained in the column, ignoring Blanks, logical values and texts.
The expression
GEOMEAN(table[column])
It is equivalent to
GEOMEANX(table, table[column])
Examples
We can calculate the geometric mean of the sales amounts contained in the SalesAmount column of the Sales table with the following measure:
Geometric mean = GEOMEAN(Sales[SalesAmount])
If we take it to a card-type display, the result is the following:
Related functions
Category
Statistical
