Comparing 2 different columns

[PowerBI123456]

Hi - Hope someone can help. I have 2 tables below:

I am trying to see which accounts from table 1 don't have the specific combos in table 2. In this example, it would be account C. 

[amitchandak · Accepted solution]

@PowerBI123456 ,

a new column in Table 1 =

var _cnt = countx( Table1, Table1[Code1] = Table2[Code1] && Table1[Code2] = Table2[Code2]) , Table2[Code2])

return

if(isblank(_cnt) , "Missing", "Found")