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
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
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.