Forum Discussion
Solved
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".
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.
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
Create a new column and add the following:
Column = IF ( HASONEVALUE ( Table[Enterprise_Id] ), RANKX ( ALL ( Table[Enterprise_Id] ), Table[DateCreated] ) )
- Didn't work :/
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 ) )
