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
I need to add a new column at the query editor stage where the row number is from the row above the current row
Unsure how this is done
Thanks
Solved! Go to Solution.
ok this was quite easy to do
Step 1 Add column / add index column (this gives a column with numbers starting with a selected number +1 for each row)
Step 2 Add colum / Index + 1 (index column number + 1)
Step 3 Merge Index column with step 2 column. Expand and delete column not required.
ok this was quite easy to do
Step 1 Add column / add index column (this gives a column with numbers starting with a selected number +1 for each row)
Step 2 Add colum / Index + 1 (index column number + 1)
Step 3 Merge Index column with step 2 column. Expand and delete column not required.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |