Check if columns Exists in other Table

Question

Hi,&nbsp;i'm trying to make a DAX code that&nbsp;checks whether a value from table x also exists in table y. if so then YES else NO&nbsp;this is what i got so forcalculated column = LOOKUPVALUE(tableY[columnY];'tableX'[columnX]&nbsp;thxregardsicturion

cmcmahan · Accepted Answer

You could do this with LOOKUPVALUE, but I would suggest using CONTAINS.&nbsp;CalcColumn = IF( 
    CONTAINS(tableY, tableY[columnY], tableX[columnX] ), 
    "Yes", "No")

Forum Discussion

Check if columns Exists in other Table

1 Reply

Related content

Check column for similar values

Check if a value exist in another column

Calculated column checking if value exists in another table

check if value exists in multiple columns

column deleted but column exists