Skip to main content

Power BI

Needs Votes

When we add Custom Column, allow us to choose its position

Vote (173) Share
Gil Raviv's profile image

Gil Raviv on 18 Jan 2017 22:52:14

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).

Comments (11)
Gil Raviv's profile image Profile Picture

c2edfefa 39a8-4fee-b889-52a4c1fc98bb on 05 Jul 2020 22:41:19

RE: When we add Custom Column, allow us to choose its position

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.