Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

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).
Status: Needs Votes
Comments
johnkgn
New Member
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.
fbcideas_migusr
New Member
Its basic, please indicate if it is possible or not.
carolyn_duhart
New Member
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
lwilkerson
New Member
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
mohammed_mudda2
New Member
Currently having to test calculated columns in Excel where I can change column order. Please fix soon.
pg2
New Member
'+1
mrountree1
New Member
We need this and also to be able to move columns in general.
n_barsukov
New Member
It would be great...
GreenBoy
New Member
An improvement for adding columns or moving them is desperately needed
rick_ashworth
New Member
When you have hundreds of columns and you need to add a column that is complementary to an existing column, it is best to locate the new column to its dependent. This makes for easy checking. Having the column "way out west" makes ensuring all columns are included is a pain....it also takes ages to complete