Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How can I choose specific columns from 4 different tables to create a new table with the chosen data?
Solved! Go to 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
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
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.
What would be a practical use for this?
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |