How to union or append tables with different column order?

[Anonymous]

Hi,

We have two tables created via DAX that we want to append to one table.

Because we created them via DAX we can't use Query Editor and we can't use UNION() because the order of columns is different. Newly created columns are added at the end of the first table and they need to be combined with columns at the beginning of the second table.

Any ideas on this?

[vjnvinod]

@Anonymous

selectcoloumns should do

[TomMartens · Accepted solution]

Hey,

not sure if I understand your requirements correctly, if you want to append ROWS (the combined table gets longer) maybe

SELECTCOLUMS will be helpful https://msdn.microsoft.com/en-us/query-bi/dax/selectcolumns-function-dax

If you want to make your table wider (more columns) then you might consider

• NATURALINNERJOIN https://msdn.microsoft.com/en-us/query-bi/dax/naturalinnerjoin-function-dax or
• NATURALLEFTOUTERJOUN https://msdn.microsoft.com/en-us/query-bi/dax/naturalleftouterjoin-function-dax

Maybe you also might consider to create sample data, upload a PBIX to onedrive or dropbox and share the link maybe with scribble visaulizing the expected result.

Regards,

Tom