Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I would create ID variable like this exemple :
Variable A ID
A 1
A 1
A 1
B 2
B 2
C 3
C 3
C 3
And I would like to create a formula for the variable to increment automatically when there is a new value in variable A. Can someone help me?
Thanks !
hI @Jeremy19
Try Ranking Column
ID = RANKX ( Table1, Table1[Variable A],, ASC, DENSE )