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