Forum Discussion
Solved
Comparing 2 different columns
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.
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")
1 Reply
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")