DAX Lookup

[sv12]

Hi,

I am trying write a Calculated column for below logic:

"If a value in Column 2 present anywhere in Column 1, return Yes else No"

Example:

Column 1	Column 2	Result
1	6	No
2	8	No
3	1	Yes
4	2	Yes
5	5	Yes

I appreceate any help!

Thanks

[edhans · Accepted solution]

try this:

Exists = IF('Table'[Column 2] in ALL('Table'[Column 1 ]), "Yes", "No")