Max of multiple Measure

[Andylj1]

Is it possible to create a measure that calculates the maximum value of 2 or more measures. Many thanks

 

[scottsen]

DAX has not MAX() function, so you have to fall back to something like...
=IF([Measure1] > [Measure2], [Measure1], [Measure2])

 

[Andylj1]

DAX has not MAX() function, so you have to fall back to something like...
=IF([Measure1] > [Measure2], [Measure1], [Measure2])

Many thanks for your prompt response, believe that DAX has a MAX function, but I assume you advise that it cannot be used on anything other than a column. Shall use your IF statement.

Thanks again.

Regards

Andy