Using DAX to add an incremented "step number" for each entry with the same "journey id"

[Anonymous]

Hi everyone, 

I'm attempting to autoincrement a "step" column in PowerBI, as seen in the photo below:

This is how my data is arranged. I'm looking to use DAX to do this, but can't work it out! 

Any help would be greatly appreciated!

[Anonymous]

Bonjour,

J'ai adapté la solution à mon problème et cela m'a permis d'avancer.

[az38 · Accepted solution]

Hi @Anonymous 

try calculated column

Column = RANKX(FILTER('Table1';'Table1'[Journey_ID]=EARLIER(Table1[Journey_ID]));Table1[created_at];;ASC;Dense)

do not hesitate to give a kudo to useful posts and mark solutions as solution
Linkedin