Forum Discussion
Filter column based on another column
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 |
2 Replies
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.
