Any chance you can share your .pbix? I have two tables (Table1 and Table2) They both have ID column. This . Returns true if values for all referred columns exist, or are contained, in those columns; otherwise, the function returns false. Read more, Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. A little comment to@dax ' solution: Although it looks pretty similar to mine, it will run much slower on large datasets, as it is not using a primary key for the merge. Please, note that ISEMPTY is a DAX function introduced in SQL Server 2012 SP1 CU4, so it is available in new version of Power Pivot for Excel 2010 and in Analysis Services builds greater than or equal to 11.0.3368. If columnName refers to a column in a related table then it must be fully qualified; otherwise, an error is returned. Hi, sorry I realised that I have overlooked something - the same person might have 2, Check if value is in another table and add columns in Power BI, How Intuit democratizes AI development across teams through reusability. Avoid using ISERROR or IFERROR functions to capture an error returned by LOOKUPVALUE. RELATED function (DAX) That's why it won't work in your case. CALCULATETABLE ( [,