Remove Duplicate based on multi-conditions

[KieuVuong]

Hi all

I have one trouble working with Removing Duplicate with conditions in Power Query. Could you please help?

I have table with 3 columns as below:

Article		Strategy		Supplier
11		Same		Main
11		Increase		Main
12		Same		Main
12		Increase		Main
11		Same		David
11		Increase		David

I have requirement from my work as:

- If the Articles and Strategy are duplicate, then choose Supplier David (delete Supplier Main) --> example article 11

And the desire result is 

Article		Strategy		Supplier
11		Same		David
11		Increase		David
12		Same		Main
12		Increase		Main

Could you please help me on that?

Thank you in advance!

[Jakinta · Accepted solution]

You can try steps below after your Source step.

    Grouped = Table.Group(Source, {"Article", "Strategy"}, {{"A", each let t = _ in if  Table.RowCount (t) > 1 then Table.SelectRows(t, each ([Supplier] = "David")) else t , type table [#"Article "=number, Strategy=text, #" Supplier"=text]}}),
    Expanded = Table.ExpandTableColumn(Grouped, "A", {"Supplier"}, {"Supplier"})
in
    Expanded