Forum Discussion
Solved
Help with Rank
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.
Hi,
try this in a calculated column:
Column = RANKX(FILTER('Table','Table'[Category] = EARLIER('Table'[Category])),'Table'[Value],,ASC)If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
