column to order

[PrestaPower]

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

 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. 

[themistoklis]

@PrestaPower

Create a new column and add the following:

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

[PrestaPower]

Didn't work 😕

[themistoklis · 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 )
    )

[PrestaPower]

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