Forum Discussion

sbmeder's avatar
sbmeder
Helper I
9 years ago
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...
Need Help
  • sbmeder's avatar
    sbmeder
    9 years ago

    Thank you for your response. I did an import of the tables and it appended very easily.

     

    Regards,

     

    Scott B. Meder

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

To create one master table, you perform an append.  When you want to blend data from different tables, such as a SQL join or a Lookup (or IndexMatch) from excel, you perform a merge.

  • sbmeder's avatar
    sbmeder
    Helper I
    9 years ago

    I seemed to have trouble trying to append the data. Table structures are somewhat different. For some reason, I thought I read that BI would look to see if one table had custno and invdte as data in one it would try and map in the other table?

     

    Regards,

     

    Scott