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 👍
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |