Forum Discussion
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 table with not matching values, but, instead of have blanks or empty, i would like to get something like that:
New Table NOT MATCHING
ID table 1 ID table 2
35148 NA or "blank"
35149 NA or "blank"
and i'm getting an empty table.
Any help? thanks in advance
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!
3 Replies
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 🙂
