GEOMEAN

Updated on
Rick de Groot

GEOMEAN is a DAX function that returns the geometric mean of values in a specified column.

Syntax

GEOMEAN( ColumnName )
Argument Properties Description
ColumnName Column that contains values for geometric mean.

Return Values

A decimal number.

Remarks

  • 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] )

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

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

= GEOMEAN( Investment[Return] )

Other functions related to GEOMEAN are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/geomean-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy