Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
Bonjour,
J'ai adapté la solution à mon problème et cela m'a permis d'avancer.
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