topic Calculated column checking if value exists in another table in DAX Commands and Tips

Calculated column checking if value exists in another table

Anonymous — Thu, 06 Oct 2022 15:27:24 GMT

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 — Thu, 06 Oct 2022 15:56:44 GMT

Hi Anonymous,

AilleryO — Thu, 06 Oct 2022 16:15:54 GMT

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 — Thu, 06 Oct 2022 17:08:58 GMT

Hi Anonymous

many options

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

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

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