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)
RE: When we add Custom Column, allow us to choose its position
It is so annoyying to have to build an additional step for reordering when I knew right from the beginning where I wanted a column to be placed. Please add this improvement!
RE: When we add Custom Column, allow us to choose its position
Please, please, please! Is a real basic feature, available in other softwares, that make the users loose too much time to solve it. Specially when we have to explain that structured export, should be redone to accomplish just a simple reordering is not understandable by the end customer.
Please, Please, PLEASE TEAM!
RE: When we add Custom Column, allow us to choose its position
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
RE: When we add Custom Column, allow us to choose its position
An improvement for adding columns or moving them is desperately needed
RE: When we add Custom Column, allow us to choose its position
It would be great...
RE: When we add Custom Column, allow us to choose its position
We need this and also to be able to move columns in general.
RE: When we add Custom Column, allow us to choose its position
'+1
RE: When we add Custom Column, allow us to choose its position
Currently having to test calculated columns in Excel where I can change column order. Please fix soon.
RE: When we add Custom Column, allow us to choose its position
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
RE: When we add Custom Column, allow us to choose its position
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