How to Remove duplicate from Table

Question

I have a table called Country and it has following data

CountryKey	Country Name
1	Australia
1	Aus
2	United States
2	USA
3	Canada
3	Can

and want convert data like:

CountryKey	Country Name
1	Australia
2	United States
3	Canada

Which function should you use in the query for Country Table:

Table.RemoveMatchingRows
Table.Distinct [Is this right]
Table.InDistinct
Table.ReplaceMatchingRows

https://docs.microsoft.com/en-gb/powerquery-m/table-distinct
I tried: Edit Queries-->Select your table-->Select Column-->Right Click-->Remove Duplicates--> then go to Advance Editor--> and found that #"Removed Duplicates" = Table.Distinct(#"Changed Type", {"CountryKey"})

v-xicai · Accepted Answer

Hi Anonymous&nbsp;,&nbsp;Based on my test, the Table.Distinct is right.&nbsp;&nbsp;&nbsp;&nbsp;Best Regards,Amy&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

How to Remove duplicate from Table

2 Replies

Related content

remove duplicate value within a row

Removing Duplicates

Create table to remove duplicates

How to stop PowerBI from automatically removing duplicates.

Remove duplicates bug