The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 )