Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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~
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
22 |