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 2 sheets with data
Sheet 1
Product Group 1 Customer Produc Group 2 Amount
A Hiti Arg 10
B Van Bra 20
Sheet 2
Product Group 2 Produc Group 1 Customer Amount
Vie C Chien 30
Tha D Tu 40
Now I want combine 2 sheet to 1 sheet in Power query or Power Bi, How?
Product Group 1 Product Group 2 Customer Amount
A Arg Hiti 10
B Bra Van 20
C Vie Chien 30
D Tha Tu 40
Thanks for your help!!
Hi @nmhung49 ,
Based on my test, you could achieve this result by using append function, but you need to make sure each of column name is same with the other table:
Table 1
Table 2
Append the two tables:
You could also download the pbix file to have a view.
Regards,
Daniel He
Thanks @v-danhe-msft
If I add a table 3 into data, it does not automatically update to the append1 table.
How way have we to automatically update it?
Hi @nmhung49 ,
If you want to append files automaticlly, you need to get data form files, you could refer to below link to have a view:
https://community.powerbi.com/t5/Desktop/Get-data-from-folder-and-append/td-p/526274
Regards,
Daniel He
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |