Max

[Jacy]

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)

[v-shex-msft]

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

[lisawinck · Accepted solution]

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

[Jacy]

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