Forum Discussion
Ranking within a matrix
Hi, I have a simple Matrix table. The table has 2 rows (Transaction & Code) and 1 value. My ideal ranking that I want is the column at the end. Transaction Code Value Ranking ...
create a calculated column
Ranking = RANKX(FILTER(Test,Test[Transaction]=EARLIER(Test[Transaction])),Test[Value])