SQL Server Performance

Calculate Min Of two measures

Discussion in 'Analysis Services/Data Warehousing' started by Hemanth, Sep 28, 2004.

  1. Hemanth New Member

    Hi ,

    Can anyone help me with the formula to calculate the min value of two measures.

    Thanks
    Hemanth


    Hemanth
  2. Luis Martin Moderator

    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.

Share This Page