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