Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
101 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |