Forum Discussion

Chris_23's avatar
Chris_23
Icon for Helper II rankHelper II
4 years ago
Solved

Add Index Column doesn't maintain order of previous step

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 ...
Need Help
  • Chris_23's avatar
    Chris_23
    4 years ago

    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

Chris_23's avatar
Chris_23
Icon for Helper II rankHelper II
4 years ago

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's avatar
Anonymous
Not applicable
3 years ago

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!