Skip to main content

Data Factory

Needs Votes

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

Vote (210) 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).

Administrator on 15 Aug 2024 18:32:57

Update 8/15/2024: Moved from Power BI ideas to Data Factory ideas.

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

Pedro Montes on 05 Jul 2020 22:49:01

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

Its basic, please indicate if it is possible or not.

Gil Raviv's profile image Profile Picture

General Ledger 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.