Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

RANKing

DateFundRank
01/01/2021A1
01/01/2021A1
03/01/2021A2
04/01/2021B1
05/01/2021B2
05/01/2021B2
06/01/2021C1
07/01/2021C2
08/01/2021C3

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 ! 

1 ACCEPTED SOLUTION
ribisht17
Super User
Super User

@Anonymous 

 

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

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

ribisht17_0-1660071365536.png

 

Ritesh Bisht 

View solution in original post

1 REPLY 1
ribisht17
Super User
Super User

@Anonymous 

 

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

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

ribisht17_0-1660071365536.png

 

Ritesh Bisht 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.