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
Hemanth
Hemanth
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
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>