Forum Discussion
webportal
Impactful Individual
6 years agoCheck if value in column B exists in column A
Using Power Query, I need to check for each row of MyTable if the value in column B exists in column A.
If it does, then that value should be returned, then an empy field.
This is the code I'm trying to enter into an if statement somehow:
Table.Contains(MyTable,[B],[A])
Which is returing a cyclical reference error.
5 Replies
- artemus
Microsoft Employee
Assuming this is in AddColumns...
Just use:
if Text.Contains([A], [B]) then [B] else null