Custom column Index by other column

[LelecoLima]

Dear friends I am facing some difficults to create a index column that will increment 1 each time the value in another column change. Below sample data:

-The "periods" column is the reference, il will keep growing ordenally like the sample and the index column is the way I wanted dax formula to write the index. Could anyone help me with this?

[Anonymous]

HI @LelecoLima,

Can you please share some sample data for test? I think it will be help for formula coding.

BTW, I'm not so sure if it is possible to nested use related function in rankx formula.

Regards,

Xiaoxin Sheng

[ChandeepChhabra · Accepted solution]

@LelecoLima Please try the following calcualted column

Month = MONTH(DATEVALUE(1&"-"&LEFT(Data[Periods],3)&"- 2016"))

If Feb is written as fev in the default date settings of your computer, then I am hopeful that this should work