Forum Discussion

rungekan's avatar
rungekan
New Member
1 year ago
Solved

Error using SELECTCOLUMNS when adding more than one column

Hi, 

 

I am trying to create a new table based on the existing one using SELECTCOLUMNS

 

When I run: 

 

TablaColumnasBasicas = 
SELECTCOLUMNS(
    'Manuf',
    "PipeBridge", 'Manuf'[GeneralPipeBrichColumns]
)

It works fine. 

 

However, when I add a second column: 

TablaColumnasBasicas = 
SELECTCOLUMNS(
    'Manuf',
    "Week", 'Manuf'[GeneralWeek],
    "PipeBridge", 'Manuf'[GeneralPipeBrichColumns]
)

I get the following error: 

 

"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

 

Table looks as follows: 

 

The table 'Manuf' is a new table I just create there are no measures or relationships yet. Column names are correct (IntelliSense
confirms them).


I tried to reduce the problem to this simplest expression, but I am stuck here.


Does anyone know Why adding a second column triggers this error?


Thanks a lot in advance!

 

  • Please make sure that, by mistake, you are not creating a measure and not a calculated table

     

    I replicated your code and I did not get an error when creating a table but I did when, by mistake myself, I clicked on new measure and not new table

     

    If this helped, please consider giving kudos and mark as a solution

    me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

2 Replies

  • Please make sure that, by mistake, you are not creating a measure and not a calculated table

     

    I replicated your code and I did not get an error when creating a table but I did when, by mistake myself, I clicked on new measure and not new table

     

    If this helped, please consider giving kudos and mark as a solution

    me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI