The MEDIAN function returns the median of the numbers in a column.
Syntax
MEDIAN(
column
)
Parameters
- column: Column containing the numbers whose median is to be obtained.
Returned value
The MEDIAN function returns a real number.
Additional Information
This function only considers numeric values, ignoring Blanks, logical values and text strings.
The expression
MEDIAN(table[column])
...is equivalent to:
MEDIANX(table, table[column])
Examples
If we have in the TotalChildren field of the Customer table the number of children of each customer, we can calculate the median with the following measure:
Median number of children = MEDIAN(Customer[TotalChildren])
Taking it to a card-type display we obtain the following result:
Related functions
Category
Statistical