Filter column based on another column

[Anonymous]

Hello 

I am struggling with creating a dimension table for Customers. I have different tables which I merged. 

Now I have a column called Customer ID and one called Channel. 

The problem is that when merging I get duplicates. 

I would like to remove the duplicates only when the value in column Channels is 10. 

Can anybody help how to do this in Power Query?

Input	Customer ID	Channels
11167	40
11167	10
11169	40
11169	10
11170	40
11170	10
Output	Customer ID	Channels
11167	10
11169	10
11170	10

[Anonymous]

Thank you! I will try out

[AndrewPF]

You could try:

split the table into two: table 1 where ID = 40 and table 2 where ID = 10; 

remove duplicates in table 2; 

recombine tables.