Forum Discussion
Solved
Append Data Merge Data
When we archive data in our ERP system it moves the transaction data from the current data ARTRAN to an archive table ARYTRN. My DAX abilities are limited, but I would think I would need to merge? t...
Thank you for your response. I did an import of the tables and it appended very easily.
Regards,
Scott B. Meder
You can use the DAX method UNION to merge the 2 tables within PowerBI as long as the 2 tables have the same columns. Under the modeling tab select New Table, and enter the expression below.
New Table = union(ARYTRN , ARTRAN)
Hope this helps.
In the query editor you can append without worrying about table structure and the resulting table will have better compression.