Forum Discussion
Solved
not matching values
Hi all, I have two tables joined by ID. Table1: ID Category 35146 A 35147 B 35148 C 35149 D Table2: ID 35146 35147 I would like to get a ta...
fiorela here is the DAX expression to create a new table of missing Ids
New Table = ADDCOLUMNS ( EXCEPT ( VALUES ( Data[Id] ), VALUES ( Master[Id] ) ), "Value", "NA" )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
fiorela here is the DAX expression to create a new table of missing Ids
New Table = ADDCOLUMNS ( EXCEPT ( VALUES ( Data[Id] ), VALUES ( Master[Id] ) ), "Value", "NA" )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Excellent, it works. You rock ! many thanks 🙂