cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PrestaPower Frequent Visitor
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

Accepted Solutions
themistoklis New Contributor
New Contributor

Re: column to order

@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 )
    )
4 REPLIES 4
themistoklis New Contributor
New Contributor

Re: column to order

@PrestaPower

 

Create a new column and add the following:

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

Re: column to order

Didn't work :/
themistoklis New Contributor
New Contributor

Re: column to order

@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 Frequent Visitor
Frequent Visitor

Re: column to order

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