Analysis Services
Median
Returns the median value of a numeric expression evaluated over a set.
Syntax
Median(«Set»[, «Numeric Expression»])
Remarks
The Median function returns the median value of a numeric expression, specified in «Numeric Expression», evaluated over a set specified in «Set».
Example
The following example returns 2000 if respective Sales of the countries are 1000, 2000, and 3000:
Median({USA, CANADA, MEXICO}, Sales)