Forum Discussion
paulfink
Post Patron
Post PatronMerge two tables using DAX
hi guys, need some help with the problem above. I have two tables, table A and table B - A is old data from our old system and B is new data from our new system. They both have the same forma...
There different joins kinds, you may try NATURALINNERJOIN in your scenario.
Reference:
NATURALINNERJOIN function (DAX) - DAX | Microsoft DocsNATURALLEFTOUTERJOIN function (DAX) - DAX | Microsoft Docs
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super Userpaulfink , union should work in this case. make sure you column names are the same or use selectcolumns, to rename columns and use them in union
https://docs.microsoft.com/en-us/dax/selectcolumns-function-dax
Also refer : https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/