Forum Discussion
Merging Data
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