Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello guys,
I have a problem with maintaining the order of each row by adding a index column.
The following table:
First the column 'Filter' is sorted in ascending order.
Based on this step, an index column should now be added. However, adding it discards the order of the previous step.
I have tried unsuccessfully to work with Table.Buffer.
Any ideas how adding an index column preserves the order of the previous step?
Kind regards
Chris
Solved! Go to Solution.
i have find the problem. Some steps before i already had sorted by column Filter. However that leeded to the mentioned problem. After delete this step all works fine. thanks
" After delete this step all works fine. " ?? What step?
i have find the problem. Some steps before i already had sorted by column Filter. However that leeded to the mentioned problem. After delete this step all works fine. thanks
I'm having the same problem with Table.Range(). For some reason, the function don't get the right row informed. And when I used Table.AddIndexColumn(), the order of the table rows changes completely. I have no clue why Power Query doesn't maintain the order from one step to another. It doesn't make any sense at all!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
11 | |
11 | |
9 | |
6 | |
6 |