Forum Discussion
Highest Status
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?
Hi Anonymous ,
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~
2 Replies
Hi Anonymous ,
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~