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 no...
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 ) )
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 ) )Thanks themistoklis, it worked ! You made my day !
