DAX Function Guide

GEOMEANX
Empty image or helper icon

Sam McKay

CEO & Founder

How does the GEOMEANX work?
GEOMEANX function returns the geometric mean of an evaluated expression for each line in a table.
GEOMEANX Formula Syntax
GEOMEANX(<table>, <expression>) 
How do you use the GEOMEANX?

The GEOMEANX method takes a table, or an expression that returns a table, as its first argument. The second argument is a column containing the numbers you want to compute the geometric mean for, or a column-evaluating expression.

Related Blog Posts

Loading

Considerations when using the GEOMEANX?

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

To return the geometric mean of the numbers in a column, use GEOMEAN function (DAX).

Related Video Tutorials

Loading

Formula examples using the GEOMEANX
=GEOMEANX( Investments, Investments[ReturnPct] + 1 ) 
Related Courses

Loading