Forum Discussion
The column order in Data table isn't the same as in Power Query!
Hello friends, I've been googling for a solution to no avail. I want the order of columns in data table view to be the same as it is in Power Query Editor. How can I force Data Table to display c...
Resurrecting an old query which I have found the solution for (as I was also impacted)
Using the scenario that you have 2 tables with the values Name, Age and City (in different orders)
Create a new table, using the below DAX will reorder the columns. Repeat for the 2nd table changing the table name. And then using the union function - New_Sorted_Tickets = UNION('Table1_Aligned','Table2_Aligned') you will have expected output.
Table1_Aligned =
SELECTCOLUMNS(
Table1,
"Name", [Name],
"Age", [Age],
"City", [City]
)