Creating a sequential column with a condition

[GeraSanz11]

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 

[Zubair_Muhammad · Accepted solution]

@GeraSanz11

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
)