Calculate Min Of two measures | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Calculate Min Of two measures

Hi , Can anyone help me with the formula to calculate the min value of two measures. Thanks
That is from BOL (Analysis Services)(I’m not expert) 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
If the respective values in the Sales measure for the USA, CANADA and MEXICO members are 1000, 2000, and 3000, the following example returns 1000: Min({USA, CANADA, MEXICO}, Sales)
HTH Luis Martin
Moderator All postings are provided “AS IS” with no warranties for accuracy.