Two excel files - remove duplications and create a new one

[Anonymous]

hi all

I am sure its super easy but I am not sure why I am not able to sort it out

I have two files of sales orders, in the second one I have some duplicated sales orders , so i want to create a third one , merging both but without duplicated .

Also I have another file with all order numbers but with no customer name that is in the first one, so I will do a relationship with the sales order number and I hope to have all the results.

How can I do the first step? sorry if I have not explained very good

Thanks!

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

You could use Append Queries feature in Query Editor.

https://docs.microsoft.com/en-us/power-query/append-queries 

Then delete the duplicate rows.

https://docs.microsoft.com/en-us/power-query/working-with-duplicates#remove-duplicates 

Or you could create a new table use DAX function DISTINCT() and UNION().

new table = DISTINCT(UNION('Table','Table (2)'))

Best Regards,

Jay

[amitchandak]

@Anonymous , Not very clear .

Append in Power Query and delete duplicates

Merge in power Query and Aggregate

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Delete duplicate https://www.youtube.com/watch?v=Hc5bIXkpGVE

https://radacad.com/power-bi-aggregation-step-1-create-the-aggregated-table