Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
46 | |
44 | |
28 | |
22 |