Forum Discussion

BogdanP's avatar
BogdanP
Frequent Visitor
10 years ago
Solved

Merging two data tables

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 P...
Need Help
  • RafDelgado's avatar
    RafDelgado
    10 years ago

    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

RafDelgado's avatar
RafDelgado
Icon for Helper II rankHelper II
10 years ago

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's avatar
BogdanP
Frequent Visitor
10 years ago

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.