Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated column checking if value exists in another table

Hi,

 

I have 2 different tables

1st Table :  14000 names

2 nd table : 25000 names

I would like to add a column to 2nd Table : True if same value as 1st table , False for missing value

 

Thank you in advance.

 

3 Replies

  • AilleryO's avatar
    AilleryO
    Memorable Member
    3 years ago

    Hi,

    I do agree with BITomS if your absolutely need:want to do it in DAX.

    My solution would be using a merge in Power Query between both tables.

    Let us know if you need more details

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Hi Anonymous 

    many options

    Table2[Name] IN VALUES ( Table1[Name] )

    or

    CONTAINS ( Table1, Table1[Name], Table2[Name] )

    or

    NOT ISEMPTY ( FILTER ( Table1, Table1[Name] = Table2[Name] ) )