Issue while merging tables in Power BI

[Analitika]

Hi,

I wanted to merge two tables, but getting issue, some data duplicated. Obj_kod column.

One table

Another table

[v-rzhou-msft · Accepted solution]

Hi @Analitika ,

According to your statement and your screenshot, I think there are duplicates in both tables, like "SK" in table1 and "DV" in table2.

If you merge tables by these columns, Power BI will give you all possible expanding results. You can merge tables by more columns, these will give more condtions to Power BI and return more precise results.

For reference:

Merge queries overview

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.