Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there!
Im trying to add a column with numerical sequence but depending on the value of another column for example
Period | id_Person | Value | Sequential #
Jan2016 | Person 1 | 123 | 1
Feb2016 | Person 1 | 12 | 2
Mar2016 | Person 1 | 1243 | 3
Apr2016 | Person 1 | 564 | 4
Jun2017 | Person 2 | 29 | 1
Jul2017 | Person 2 | 154 | 2
Ags2017 | Person 2 | 1211 | 3
So, the idea is to have a sequential depending on the person, the objective is to compare periods but i need to compare period 1 from person 1 with period 1 from person 2, and so on until period 3, since person 2 doesnt have period 4 (also there are multiple persons)
Any ideas?
thx in regards
Solved! Go to Solution.
If your period column is of Date Type you can use following calculated column
Sequential # = RANKX ( FILTER ( Table1, Table1[id_Person] = EARLIER ( Table1[id_Person] ) ), Table1[Period], , ASC, DENSE )
If your period column is of Date Type you can use following calculated column
Sequential # = RANKX ( FILTER ( Table1, Table1[id_Person] = EARLIER ( Table1[id_Person] ) ), Table1[Period], , ASC, DENSE )
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |