Forum Discussion
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)
Have you tried using a New Column rather than a new Measure?
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