Forum Discussion

Tabular's avatar
Tabular
Regular Visitor
3 years ago
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...
Need Help
  • danextian's avatar
    danextian
    3 years ago

    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.

     

Tabular's avatar
Tabular
Regular Visitor
3 years ago

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?

danextian's avatar
danextian
Super User
3 years ago

SELECTCOLUMN is a table function and should be used in a calculated table. What are trying this function for as a measure?

  • Tabular's avatar
    Tabular
    Regular Visitor
    3 years ago

    Yes that was my problem. I didn't realize I set the other up this way, thank you.