Merging two data tables

[BogdanP]

Hello everyone, I am very new to PowerBI, so apologies if my question is too dumb.

Consider following data structure:

 As you can see, there are 3 lookup tables and 2 data tables. Set of Producers in "Import" table is slightly different than in "V" table. Apart from that these two tables are almost identical. 

So what exactly am I trying to achieve here? I want to create a single data table, containing following columns: "Producer", "Date", "Dimension", "Volume" and "Import". Appending queries didn't work because it duplicates producers, so merging queries is presumably the way to approach it. However, I was unable to achieve desired result.

Thank you in advance, any help is appreciated.

[RafDelgado · Accepted solution]

Hey Bogdan, 

You have the relationships showing so you can still make a single visual table using the related information from the 2 data tables. If you really need a single table, what join kind are you trying on the merge? Could you not match the two table columns, merge and remove all the duplicates?

Thanks,

Raf

[BogdanP]

Hey Raf,

Thank you for your answer. It pushed me in the right direction - have to admit that i completely forgot that PowerBI has "remove duplicates" feature similar to Excel one. So appending these tables and then clearing the duplicates worked for me really well. Thank you once more.