Forum Discussion
hejszyszky
Helper II
Helper IIReordering for union purposes
Hi, im having one power query table and one dax calculated table. What is the most optimized way to reorder columns position in order to perform union? Also which view is the output view? Cuz in ...
hejszyszky you have to do in DAX, use selectcolumns and then do union
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Pragati11
Super User
Super UserHI hejszyszky ,
I don't think it actually matters where you create the table. I prefer creating in in Power Query, so that I have everything done before I get data for reporting in Power BI.
Can you share some screenshots on column re-ordering differences from Power Query & DAX created tables?
Ideally, if you re-order columns in Power Query for a table, it should reflect the DATA tab once the query changes have been applied.