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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
PrestaPower
Frequent Visitor

Ordering a column by giving an another column with the order

Hey, so here is my concern.

 

I would like to be able to get a new column that gives me the "number" of the step for each enterprise using the date. I already know how to get the latest date but not finding anything regarding my issue.  For example in this table i have 2 enterprises. Each of them went trhow different steps of a process at each "Date Created". 

Capture.PNG

 What i'm looking to get is for example, for enterprise 3575, the change made on 13/11 returns a 1, the one for 14/11 a 2, the one for 20/11 a 3 and the one for 21/11 a 4 in a new column. 

1 ACCEPTED SOLUTION
AlB
Community Champion
Community Champion

Hi @PrestaPower

 

You can use RANKX for that

View solution in original post

1 REPLY 1
AlB
Community Champion
Community Champion

Hi @PrestaPower

 

You can use RANKX for that

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors
Top Kudoed Authors