When we add Custom Column, allow us to choose its position
When we add a new column in the Query Editor, it always places the column at the end. This makes it difficult to visualy relate the new column with the other columns that were used in the calculation, and make if difficult to debug our custom column code. The workaround to use ordering after we add the column, is not user friendly if we have dozens of columns.
It would be helpful, if we can choose the location of the column from the UI (with a default), and that you add a fourth optional parameter in Table.AddColumn for the column that the new column will be added after.
Note: If you don't improve Table.AddColumn, and instead implement it using Table.OrderColumns, please don't refer to all the column names in the formula (It fails too often in refresh when column names are missing).
An improvement for adding columns or moving them is desperately needed
It would be great...
We need this and also to be able to move columns in general.
Currently having to test calculated columns in Excel where I can change column order. Please fix soon.
We need this and to be able to move columns in general. Doing this with a Direct Query connection is causing an warning. This is a very basic thing to be able to do and makes tables infinitely more readable
and when a query has been edited to add a column, we need to be able to choose the position where it is to be added
Pedro Montes commented
Its basic, please indicate if it is possible or not.
General Ledger commented
It would be great if we could select a column in Power Query and then selecting Add Custom Column would insert the new column to the left of the previously selected column. Much like inserting a blank column in Excel works.