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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Rankx with Dates

 

Hi all, 

 

I have the table like that and want to create a report with a RankX

 

 

CustomerMaterialOrder DateRankX
A1231.1.20191
A1231.1.20192
A1233.3.20193
A14510.1.20191
A1865.1.20191
A1867.1.20192
B12320.1.20192
B1239.1.20191

 

Can somebody help me with that? 

 

Thanks

Christoph

 

 

1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

 

Create a Calculated Column

 

RANK Column = RANKX(FILTER('Table','Table'[Customer] = EARLIER('Table'[Customer]) && 'Table'[Material]= EARLIER('Table'[Material])),'Table'[Order_date],,ASC)
 
 
1.jpg
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

View solution in original post

12 REPLIES 12

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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