Forum Discussion
Using SelectColumns to Combine Several Excel Sheets
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.
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.
Thank you. When I try this I receive the error "This expression refers to multiple columns. Multiple columns cannot be converted to a scalar value"
I've tried to use append but since the columns I want combined are not in the same column across each sheet, I'm unsure of how to allign them. What would this function be called?
