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. ThanksHemanth
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.
]]>