Merge tables in Power BI

[analitika123]

Hi,

I need to merge tables in Power BI. Whenever I merge tables, I am getting cross join situation. Instead one row I am getting much more values, seems it generates all possible combinations. I understand that it need more columns to form a key but actually I have two related columns which unfortunately have duplicates. So how to resolve my issue?

[Anonymous · Accepted solution]

HI

Bellow you have the Join Kind Options. I Guess you are looking for the inner Join

If you are not familiar with them, please check this article.

https://radacad.com/choose-the-right-merge-join-type-in-power-bi

Also, if none of those joins fulfill your needs, you should probably do a Full Outter Join and transform the subsequent data in powerQuery

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂