MEDIAN Function (DAX)

How does the MEDIAN function (DAX) work?

It returns the median of numbers within a column.

Use MEDIANX function (DAX) to return the median of an evaluated expression for each row in a table.

MEDIAN Formula Syntax

MEDIAN(
     <column>
)

How do you use the MEDIAN function?

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

Related Blog Posts

Related Support Forum Posts

Median Of A Time Column
Get Median Value by Patient (In correct result)
Measure To Calculate Median Sale Price

Considerations when using the MEDIAN function

Only the column numbers are considered.

Blanks, logical values, and text are ignored.

Related Video Tutorials

What-Is-DAX-Why-Do-You-Need-To-Learn-It-1.2-Ultimate-Beginner-Guide-to-DAX

Formula examples using the MEDIAN function

= MEDIAN (
    Customers[Age]
)

= MEDIAN (
     Sales[Sales Amount]
)

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership