DAX Function Guide

MEDIAN
Empty image or helper icon

Sam McKay

CEO & Founder

How does the MEDIAN 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?

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

Related Blog Posts

Loading

Considerations when using the MEDIAN?

Only the column numbers are considered.

Blanks, logical values, and text are ignored.

Related Video Tutorials

Loading

Formula examples using the MEDIAN

= MEDIAN (
    Customers[Age]
)

= MEDIAN (
     Sales[Sales Amount]
)

Related Courses

Loading