DAX Statistical - GEOMEANX function

Description

Returns the geometric mean of an expression evaluated for each row in a table. DAX GEOMEANX function is new in Excel 2016.

Syntax

GEOMEANX (<table>, <expression>)

Parameters

Sr.No. Parameter & Description
1

table

The table containing the rows for which the expression will be evaluated.
2

expression

The expression to be evaluated for each row of the table.

Return Value

A decimal number.

Remarks

  • The first parameter is a table, or an expression that returns a table.

  • The second parameter is a column that contains the numbers for which you want to compute the geometric mean, or an expression that evaluates to a column.

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

Example

= GEOMEANX (Sales,Sales[Sales Amount])
dax_functions_statistical.htm
Advertisements