Select max value in column based on another column

[AOT]

I am looking to select the Max value in eip_value based on the key column. How do I write a Dax function to do this?

[ImkeF]

Do you want it as a column or a measure?

[AOT]

Hi,

I want it as a column, thanks

[ImkeF · Accepted solution]

You could write it like so:

CALCULATE(MAX('Table'[eip_value]), ALLEXCEPT('Table', 'Table'[Key]))

Please make sure to use that in the data view, as it is a DAX-function.

[AOT]

what if I want to write it as an M query in the advanced editor?

[AOT]

This worked. Thank you.