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
    Hemanth, Sep 28, 2004
    #2

  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.

    Luis Martin, Sep 28, 2004
    #2

Share This Page