How to avoid duplicates when merging?

[elmarthg]

Hello,

I am trying to merge two datasets but I am getting duplicates or datapoints getting bloated. I tried removing duplicates but my numbers in the merged table is different from the other two. 

[v-cgao-msft · Accepted solution]

Hi @elmarthg ,

1. Is it possible to add more column pairs besides the [regardingobjectid] column?

Solved: merging causes duplicates

2. Does the null in the [regardingobjectid] column make sense? If not, you can filter it and merge the query.

3. Please try the step like this.

= Table.TransformColumns(#"Merged Queries",{"Table2",each Table.Distinct(_)})

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum