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
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.
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 |
---|---|
99 | |
98 | |
79 | |
74 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |