Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
User | Count |
---|---|
106 | |
90 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |