CODEWITHSUNDEEP
powerbipowerquery
Toolarny Ntuta
Toolarny Ntuta

Reputation: 11

Remove duplicates in Power Query (BI)

I have retentions agents for an insurance company entering data on a google form. They work on different policies and sometimes capture the same policy twice. There is also a scenario where they would work on the same policy in different months. I would therefore like to remove duplicates that occur in the same month but keep them if they occur in different months. How can I do this on Power Query?

Upvotes: 0

Views: 167

Answers (1)

horseyride
horseyride

Reputation: 21318

click Select the columns you want to check (policy and month) and then right click remove duplicates

#"Removed Duplicates" = Table.Distinct(#"YourPriorStepNameHere", {"month", "policy"})

Upvotes: 1

Related Questions