Forum Discussion
Select Columns from 4 Tables to create a New table
How can I choose specific columns from 4 different tables to create a new table with the chosen data?
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
4 Replies
v-yuta-msftCommunity Support
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
What would be a practical use for this?
BirinderHelper III
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.
- Greg_Deckler
Community Champion
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
