Forum Discussion
nmhung49
Helper II
Helper IICombine Data with Different Columns on Multiple Sheets into a Single Sheet
I have 2 sheets with data Sheet 1 Product Group 1 Customer Produc Group 2 Amount A Hiti Arg 10 B ...
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi 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
nmhung49Helper II
Helper IIThanks 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?
- v-danhe-msft
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