Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have load 4 tables from google analytics with idetntial fields.
i need to union this tables and work with union data, but field's sorting in one table is differ from other: http://joxi.ru/vAWDOn6S1kNabr
Why and how fix this trouble?
Solved! Go to Solution.
Hi @serjio,
You can try to use below methods to merge tables.
1. Power query:Table.SelectColumns ,Table.Combine
Sample:
MergeTable= Table.Combine( Table.SelectColumns(Table1,{"Column1","Column2","Column3"}), Table.SelectColumns(Table2,{"Column1","Column2","Column3"}), Table.SelectColumns(Table3,{"Column1","Column2","Column3"}), Table.SelectColumns(Table4,{"Column1","Column2","Column3"}))
2. Dax formula. Selectcolumns, union functions.
Sample formula:
Table 2 = UNION( SELECTCOLUMNS('Table',"Column1",[Column1],"Column2",[Column2],"Column3",[Column3]), SELECTCOLUMNS('Table2',"Column1",[Column1],"Column2",[Column2],"Column3",[Column3]), SELECTCOLUMNS('Table3',"Column1",[Column1],"Column2",[Column2],"Column3",[Column3]), SELECTCOLUMNS('Table3',"Column1",[Column1],"Column2",[Column2],"Column3",[Column3]) )
Reference links:
Dax:
Power query:
Regards,
Xiaoxin Sheng
Cool,
We have to in Power Query. but we can do in DAX also. but in DAX it will createing Performance Issue.
So best way is go with Power Query.
SO we have option to Append your four table and create new table. follow the below steps
Let me know if any help
Hi @serjio,
You can try to use below methods to merge tables.
1. Power query:Table.SelectColumns ,Table.Combine
Sample:
MergeTable= Table.Combine( Table.SelectColumns(Table1,{"Column1","Column2","Column3"}), Table.SelectColumns(Table2,{"Column1","Column2","Column3"}), Table.SelectColumns(Table3,{"Column1","Column2","Column3"}), Table.SelectColumns(Table4,{"Column1","Column2","Column3"}))
2. Dax formula. Selectcolumns, union functions.
Sample formula:
Table 2 = UNION( SELECTCOLUMNS('Table',"Column1",[Column1],"Column2",[Column2],"Column3",[Column3]), SELECTCOLUMNS('Table2',"Column1",[Column1],"Column2",[Column2],"Column3",[Column3]), SELECTCOLUMNS('Table3',"Column1",[Column1],"Column2",[Column2],"Column3",[Column3]), SELECTCOLUMNS('Table3',"Column1",[Column1],"Column2",[Column2],"Column3",[Column3]) )
Reference links:
Dax:
Power query:
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |