Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi can anyone help me with merging data
I have 2 table which I neeed to merge, but I dont have any relationship to this table
the reason why I need to merge is, I want to combined the values from 2 different tables
table 1
Type Average
A 15
B 11
C 10
D 9
table 2
TypeCategory Avg
E 15
F 16
G. 9
H. 5
so this should results of
Category Avg
A. 15
B. 11
C. 10
D. 9
E. 15
F. 16
G. 9
H. 5
Hi @tebtim19
Go to Power Query
In table1 and rename the column, "Type" as "Categoty" and "Average" as "AVG"
In table2 and rename the column, "TypeCategory" as "Categoty"
Go to Append or Append as New and marge the data
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
Hio @tebtim19 ,
I think you a few options here.
One way would be to rename the columns for one of the tables and then use the Append Queries function in Power Query:
Another way would be to use the UNION function in DAX:
Here the code:
NewTable2 = UNION (Table1, Table2)
Does this help? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
How about if one of the column is have more data than the other column. For example?
table 1
Type Average
A 15
B 11
C 10
D 9
table 2
TypeCategory Avg
E 15
F 16
G. 9
H. 5
I 1
J 2
so this should results of
Category Avg
A. 15
B. 11
C. 10
D. 9
E. 15
F. 16
G. 9
H. 5
I 1
J 2
HI @tebtim19
For example , If you have 4 rows in one table1 and 150 rows in another table2.
Append in Power Query
and Union in Power BI Desktop will both works
It is not depends on the ROWS number in both table, The column name should be same when you going to append two or more tables.
Go to Power Query
In table1 and rename the column, "Type" as "Categoty" and "Average" as "AVG"
In table2 and rename the column, "TypeCategory" as "Categoty"
Go to Append or Append as New and marge the data
Hope this notes helps you
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |