Select Columns from 4 Tables to create a New table

[garimaa85]

How can I choose specific columns from 4 different tables to create a new table with the chosen data?

[v-yuta-msft · Accepted solution]

Hi garimaa85,

Use SUMMARIZE(), SELECTCOLUMNS(), ADDCOLUMNS() can meet your requirement, try these two solutions in DAX like patterns below:

//Solution1
New Table =
UNION (
    SUMMARIZE ( Table1, [Group_by_Me], "Column1", [Column1] ),
    SUMMARIZE ( Table2, [Group_by_Me], "Column2", [Column2] ),
    SUMMARIZE ( Table3, [Group_by_Me], "Column3", [Column3] ),
    SUMMARIZE ( Table4, [Group_by_Me], "Column4", [Column4] )
)

//Solution2
New Table =
UNION (
    SELECTCOLUMNS ( Table1, "Column1", [Column1] ),
    SELECTCOLUMNS ( Table2, "Column2", [Column2] ),
    SELECTCOLUMNS ( Table3, "Column3", [Column3] ),
    SELECTCOLUMNS ( Table4, "Column4", [Column4] )
)

Regards,

Jimmy Tao

[Birinder]

hi @bcdobbs 
I couldn't remember any other member to mention. So I mentioned you here.
It is quite urgent and simple case, but it is causing me a lot of hours.

Actually my situation is exactly same like the Guy's above.
Except the solution isn't working.
The union command is just stacking up the rows, all under the one column.
Please help me.
I sincerely apologize for just bringin you into all this.

[jford4]

What would be a practical use for this?

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490