Error using SELECTCOLUMNS when adding more than one column

[rungekan]

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!

[FBergamaschi · Accepted solution]

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

[rungekan]

Thanks a lot, that was it.