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.
I have data simillar to below table.
Category | pair | Value |
A | B | 10 |
A | C | 15 |
B | D | 20 |
B | A | 25 |
I need a rank column simillar ranking as per category and value. Below O/p.
Category | pair | Value | Rank |
A | B | 10 | 1 |
A | C | 15 | 2 |
B | D | 25 | 2 |
B | A | 20 | 1 |
I have tried Rankx but I am not getting the expected o/p. Any help is appreciated. Thanks.
Solved! Go to Solution.
Hi,
try this in a calculated column:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Works!!! Thanks a lot.
Hi,
try this in a calculated column:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
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 |
---|---|
88 | |
85 | |
68 | |
66 | |
64 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |