Forum Discussion
Solved
Using SelectColumns to Combine Several Excel Sheets
Hello, I have several Excel sheets with 'product' info and the date they were 'sold'. The columns for the products is split across varying columns and do not line up. I was able to circumvent thi...
Hi Tabular ,
This is how you select multiple columns from the same table using SELECTCOLUMNS
= SELECTCOLUMNS ( 'Products1', "Scope", 'Products1'[Column2], "Date", 'Products1'[Column8] )Also, instead of creating a untion in DAX, have you tried appending each table to one another in Power Query? That basically creates a union as well.
