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 ...
  • AilleryO's avatar
    AilleryO
    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
    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] ) )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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] ) )