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. ...
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 👍
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 👍