Forum Discussion

Milagros's avatar
Milagros
Icon for Helper I rankHelper I
4 years ago

Table Function, Filter table for values NOT in another table

Hi there, I have two tables. Tabe 1 All reference numbers, Table 2 Some reference numbers. I am trying to filter Table 1 to show only those reference numbers that do not appear in table 2. I tried th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Milagros Try something like this:

Not in Table 2=var tempFilter=EXCEPT(VALUES(Table 1[referenceNumber]),VALUES(Table 2[referenceNumber]))

return FILTER(Table 1,Table 1[referenceNumber] in tempFilter)