Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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] ) )
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 ) )
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |