Highest Status

[Syaza1891]

Hi, need your help on this issue:

I have this type of data: 

ID	Progress Status
001	B1
001	B2
001	B3

I'd like to have the highest status for this id will be at B3. The output that i want is like this:

ID	Progress Status	Highest Status Progress
001	B1	B3
001	B2	B3
001	B3	B3

Anyone can help?

[Syaza1891]

thank you so much!

[xifeng_L · Accepted solution]

Hi @Syaza1891 ,

You can try below column expression.

Highest Status Progress = CALCULATE(MAX('Table'[Progress Status]),ALLEXCEPT('Table','Table'[ID]))

Did I answer your question? If yes, pls mark my post as a solution!

Thank you~