'List.contains not working with a column as second argument in Power query M

Gives F for everything as far as I can see when there are common values in columns A and B

each if List.Contains(List.RemoveNulls( { [A] } ),[B]) = true then "T" else "F"

Thanks for the help :)

listpowerbipowerquery


Solution 1:[1]

In powerquery, to check if each row's value in column a matches column b in any row

add column .. custom column.. with formula

= if List.Contains(PriorStepNameHere[b],[a]) then "T" else "F"

Is that what you are looking for?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 horseyride

Related Questions