Forum Discussion
Transfer data beetween two tables
Example data would be great. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, you should be able to use a Merge query to merge the records. Otherwise, you could create a new table in DAX using something like NATURALINNERJOIN or SUMMARIZE, or just create a relationship between the tables and not worry about duplicating data.
Community ChampionExample data would be great. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, you should be able to use a Merge query to merge the records. Otherwise, you could create a new table in DAX using something like NATURALINNERJOIN or SUMMARIZE, or just create a relationship between the tables and not worry about duplicating data.