Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    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~

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

thank you so much!