Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to 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~
thank you so much!
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~
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |