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 ) )
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 !