Power bi-Merge query as left out join is showing duplicate results - how to resolve that

[RUPSY777]

Hi ,

i am trying to merge three tables using a left outer join ( first i merged first two tables using a left outer join and then did merge with third table with left outer join) - the master table contained unique matching records but the other two tables duplicate entries so i did left outer join (1:m relantionshop)-- now this is causing duplicates. Can you help as how to resolve this ? 

[az38 · Accepted solution]

Hi @RUPSY777 

what do you want to achieve?

Maybe it will be enough to just put columns into visual without additional joining?

[RUPSY777 · Accepted solution]

thanks it got solved by choosing the aggregate function in expansion for merge join.

[Icey]

Hi @RUPSY777 ,

Glad to hear that. You may help accept your reply above as the solution. Your contribution is highly appreciated.

Best Regards,

Icey

[az38 · Accepted solution]

Hi @RUPSY777 

what do you want to achieve?

Maybe it will be enough to just put columns into visual without additional joining?