Calculated column checking if value exists in another table

[Anonymous]

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.

[BITomS · Accepted solution]

Hi @Anonymous,

Think this function is what you're after: https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax 

[AilleryO · Accepted solution]

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 · Accepted solution]

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] ) )

[AilleryO · Accepted solution]

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

[BITomS · Accepted solution]

Hi @Anonymous,

Think this function is what you're after: https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax