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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
PrestaPower
Frequent Visitor

column to 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

@PrestaPower

 

Please try the following:

 

Rank = 
VAR d = Sheet1[Date_Created]
VAR a = Sheet1[Enterprise_Id]
RETURN
    CALCULATE (
        RANK.EQ ( d, Sheet1[Date_Created], ASC ),
        FILTER ( ALL ( 'Sheet1' ), Sheet1[Enterprise_Id] = a )
    )

View solution in original post

4 REPLIES 4
themistoklis
Community Champion
Community Champion

@PrestaPower

 

Create a new column and add the following:

Column = 
IF (
    HASONEVALUE ( Table[Enterprise_Id] ),
    RANKX ( ALL ( Table[Enterprise_Id] ), Table[DateCreated] )
)
 

Didn't work 😕

@PrestaPower

 

Please try the following:

 

Rank = 
VAR d = Sheet1[Date_Created]
VAR a = Sheet1[Enterprise_Id]
RETURN
    CALCULATE (
        RANK.EQ ( d, Sheet1[Date_Created], ASC ),
        FILTER ( ALL ( 'Sheet1' ), Sheet1[Enterprise_Id] = a )
    )

Thanks @themistoklis, it worked ! You made my day !

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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