Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hey, so here is my concern.
I would like to be able to get a new column that gives me the "number" of the step for each enterprise using the date. I already know how to get the latest date but not finding anything regarding my issue. For example in this table i have 2 enterprises. Each of them went trhow different steps of a process at each "Date Created".
What i'm looking to get is for example, for enterprise 3575, the change made on 13/11 returns a 1, the one for 14/11 a 2, the one for 20/11 a 3 and the one for 21/11 a 4 in a new column.
Solved! Go to Solution.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.