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.
Hi 31Mathias,
Based on your description, I made an sample here. Actually we can create relationship between Table1 and Table2 and use the RELATED function to add a calculated column.
ca = RELATED(Table2[category])
For more details, please check the pbix as attached. If it doesn't meet your requirement, kindly share your sample data or pbix to me.
https://www.dropbox.com/s/md8vso55eef023o/Transfer%20data%20beetween%20two%20tables.pbix?dl=0
Regards,
Frank