MEDIAN
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
Returns the median of numbers in a column.
To return the median of an expresssion evaluated for each row in a table, use MEDIANX function.
Syntax
MEDIAN(<column>)
Parameters
Term | Definition |
---|---|
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 counted. Blanks are ignored. Logical values, dates, and text are not supported.
MEDIAN( Table[Column] ) is equivalent to MEDIANX( Table, Table[Column] ).
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
The following computes the median of a column named Age in a table named Customers:
= MEDIAN( Customers[Age] )
Related content
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru