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.
Go to Solution.
Think this function is what you're after: https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax
View solution in original post
I do agree with @OEMTomS 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
Table2[Name] IN VALUES ( Table1[Name] )
CONTAINS ( Table1, Table1[Name], Table2[Name] )
NOT ISEMPTY ( FILTER ( Table1, Table1[Name] = Table2[Name] ) )
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!