GEOMEAN Function (DAX)

 
System_CAPS_ICON_note.jpg Note


This function is included in SQL Server 2016 Analysis Services (SSAS), Power Pivot in Excel 2016, and Power BI Desktop only. Information provided here is subject to change.

Returns the geometric mean of the numbers in a column.

To return the geometric mean of an expression evaluated for each row in a table, use GEOMEANX Function (DAX).

GEOMEAN(<column>)  

Parameters

TermDefinition
columnThe column that contains the numbers for which the geometric mean is to be computed.

A decimal number.

Only the numbers in the column are counted. Blanks, logical values, and text are ignored.

GEOMEAN( Table[Column] ) is equivalent to GEOMEANX( Table, Table[Column] )

The following computes the geometric mean of the Return column in the Investment table:

=GEOMEAN( Investment[Return] )  

GEOMEANX Function (DAX)

Community Additions

ADD
Show: