Forum Discussion

CHARLEA1's avatar
CHARLEA1
Frequent Visitor
4 years ago
Solved

Comparing two columns for same values using powerquery

Hi there,  first time posting but I have been looking around a lot. I'm trying to create a custom column which identifies for which values in column B exists in column A (i.e. they do not need to e...
Need Help
  • CHARLEA1's avatar
    CHARLEA1
    4 years ago

    Thanks,

    solution ended up being: = Table.AddColumn(#"Previous Step", "Custom", each List.Contains(#"Previous Step"[column A], [column B]))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

It'll work if you rewrite it like:

 

= Table.AddColumn(#"Previous Step", "Custom", each List.Contains({#"Previous Step[column A], [column B]))

 

--Nate