topic Using DAX to add an incremented "step number" for each entry with the same "journey id" in DAX Commands and Tips

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

Anonymous — Tue, 03 Dec 2019 11:05:14 GMT

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!

az38 — Tue, 03 Dec 2019 18:24:01 GMT

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

Anonymous — Sat, 09 Mar 2024 23:23:49 GMT

Bonjour,

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