Hi Guys,
Is there a way to return the measure name in a DAX formula that produces the maximum value?
For example, lets say I have 3 measures that yield:
Measure 1: 25
Measure 2: 32
Measure 3: 28
I would like to create a formula which would return ‘Measure 2’ in this instance since it is the largest value.
I know this is achievable through an if statement but I wondered if there was a more elegant solution since I have lots of conditions in reality
Thanks
Is there a way to return the measure name in a DAX formula that produces the maximum value?
For example, lets say I have 3 measures that yield:
Measure 1: 25
Measure 2: 32
Measure 3: 28
I would like to create a formula which would return ‘Measure 2’ in this instance since it is the largest value.
I know this is achievable through an if statement but I wondered if there was a more elegant solution since I have lots of conditions in reality
Thanks