Forum Discussion

Jacy's avatar
Jacy
Frequent Visitor
8 years ago
Solved

Max

I need to calculate a maximum sales value of a calculation, which varies per month, but the max only accepts field as a parameter. Ex Max (sales) (take the Month with higher value)

Need Help

3 Replies

  • lisawinck's avatar
    lisawinck
    Regular Visitor
    8 years ago

    Have you tried using a New Column rather than a new Measure?

    • Jacy's avatar
      Jacy
      Frequent Visitor
      8 years ago

      Unfortunately it would not work, the calculation is variant, I can not plaster, sales is just an example, the actual calculation is turnover.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Jacy,

     

    If you want get multiple result from one measure, you should add group column to let it calculated through multiple records.

     

    Sample:

    Ex MAX = MAX('CALENDAR'[Rolling])

     

    Regards,

    Xiaoxin Sheng