DAX Help

[sv12]

Hi,

I am new to DAX and I am seeking help with the below usecase:

I want to know if column 2 value exists in column 1. And potentially use this as a slicer or column filter in power query.

I appreciate your help.

Thanks

[HotChilli · Accepted solution]

Column 2 is in 1 = IF(  Table1[Column2] IN ALL(Table1[Column1]), "Yes", "No")

Also

Column 2 is in 1 = IF(  Table1[Column2] IN DISTINCT(Table1[Column1]), "Yes", "No")