not matching values

[fiorela]

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 

[parry2k]

@fiorela why you want 3rd calculated table? You can achieve the result without creating a calculated table? What is the goal? 

[parry2k · Accepted solution]

@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]

Excellent, it works. You rock ! many thanks 🙂