Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |