Forum Discussion
Merging tables with static data and to update data
Hi all, I am trying to create a balance sheet in Power BI. I am using as data source excel data from the past year (Table A) and current year (Table B). I cannot merge the excels and have Tab...
Anonymous , Merge in Power Query and Union in DAX should work with new data as long as that is coming in both these tables
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Union(TableA, TableB)
Or use selectcolumns to get the right columns
Also refer: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Anonymous , Merge in Power Query and Union in DAX should work with new data as long as that is coming in both these tables
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Union(TableA, TableB)
Or use selectcolumns to get the right columns
Also refer: https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/