GEOMEAN DAX Function (Statistical)

Syntax  |  Return values  |  Remarks  |  Related  

Returns geometric mean of given column reference.

Syntax

GEOMEAN ( <ColumnName> )

Parameter	Attributes	Description
ColumnName		Column that contains values for geometric mean.

Return values

Scalar A single decimal value.

Return a decimal number with the geometric mean.

Remarks

The GEOMEAN function internally executes GEOMEANX, without any performance difference.
The following GEOMEAN call:

GEOMEAN ( table[column] )

corresponds to the following GEOMEANX call:

GEOMEANX (
    table,
    table[column]
)

Related functions

Other related functions are:

• GEOMEANX

Last update: Jan 11, 2021   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber

MSDN documentation: https://docs.microsoft.com/en-us/dax/geomean-function-dax