Hi, I’m very new to power query but just can’t find a suitable solution. I need to remove a row if the same value exists in another column. I know I need a conditional statement then a filter but just don’t know how to put it all together. So if ID B exists in ID A remove the corresponding ID A row.
ID A. ID B
1
2
3
4 1
5 3
so here the first and third row in ID A would be removed. I would want to keep the row where the value is duplicated in ID B
thanks for any advice.
