how to add multiple columns from multiple table with SELECTCOLUMNS?

[Anonymous]

So I am trying to add the following columns from the following tables to a new table called "updates":

Table: ComputerUpdate

Columns: ci_id, machineid, status, last status change

Table: Computer

Column: Operating System

Table: Update

Column: title

I was able to use this formula to add in one column:

updates = SELECTCOLUMN(ComputerUpdate,"ci_id",[ci_id])

I can't figure out how to use this to add more than one though. Any help would be appreciated 🙂

[harshnathani]

Hi @Anonymous ,

You can try using ADDCOLUMNS or RELATED function

https://dax.guide/addcolumns/

https://dax.guide/related/

Regards,

Harsh Nathani

[lbendlin]

once you added them what are you planning to do next?  Table variables are short lived, they only exist inside the measure they are created. 

What prevents you from letting the data model do the work?

[Anonymous]

Well I'm having some strange issues. Basically I have a measure formula that works but when I slice it, it adds things that aren't supposed to be there, I'm just experimenting to see if I bring everything into one table whether or not it will work.

I was able to come up with this so far:

UNION(SELECTCOLUMNS(ComputerUpdate,"ci_id",ComputerUpdate[ci_id]),SELECTCOLUMNS(ComputerUpdate,"machineid",ComputerUpdate[machineid]),SELECTCOLUMNS(Computer,"Operating System",Computer[Operating System]))

It works but everything is in one column instead of multiple. I know the UNION function is at fault but I don't know what else to use.

[lbendlin]

Yeah, UNION is not your friend here.

Are the tables related, or are they dangling around?  In the former case you can potentially use RELATED() references, in the latter LOOKUPVALUE()