MEDIANX

Syntax

MEDIANX(<ColumnName>)

Tutorial with example

In this series of statistical functions we are looking at the median:

Download example file:

Download Power BI file: here.

Remarks

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

MEDIAN( Table[Column] ) is equivalent to MEDIANX( Table, Table[Column] ).