RANKing

[ndris]

Date	Fund	Rank
01/01/2021	A	1
01/01/2021	A	1
03/01/2021	A	2
04/01/2021	B	1
05/01/2021	B	2
05/01/2021	B	2
06/01/2021	C	1
07/01/2021	C	2
08/01/2021	C	3

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 · Accepted solution]

@ndris 

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