DAX Statistical - MEDIAN function
Advertisements
Description
Returns the median of numbers in a column. DAX MEDIAN function is new in Excel 2016.
Syntax
MEDIAN (<column>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
column The column that contains the numbers for which the median is to be computed. |
Return Value
A decimal number.
Remarks
Only the numbers in the column are considered.
Blanks, logical values, and text are ignored.
Example
= MEDIAN (Sales[Sales Amount])
dax_functions_statistical.htm
Advertisements