Min

Analysis Services

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)