Add Index Column doesn't maintain order of previous step

[Chris_23]

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

[Anonymous]

" After delete this step all works fine. "   ??  What step?

[Chris_23 · Accepted 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

[Anonymous]

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!