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 |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |