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
Formula examples using the MEDIAN function
= MEDIAN (
Customers[Age]
)
= MEDIAN (
Sales[Sales Amount]
)