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

 

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