Solved: RANKing

Anonymous · ‎08-09-2022

Hello Everyone ,

Please i need your help on my issue , look the table above for get more detail about it .

I want to do that in dax query and power query .

Thanks in advance !

ribisht17 · ‎08-09-2022

@Anonymous

NOTE: Need to add the index to differentiate the first 2 rows here

RANK=RANKX(fILTER(Table1,[Category]=EARLIER([Category])),[Date],,DESC,dENSE)

Ritesh Bisht

ribisht17 · ‎08-09-2022

@Anonymous

NOTE: Need to add the index to differentiate the first 2 rows here

RANK=RANKX(fILTER(Table1,[Category]=EARLIER([Category])),[Date],,DESC,dENSE)

Ritesh Bisht

RANKing