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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors