Forum Discussion
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...
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)
Hi Marik, Thank you I tried the suggestion but got this message. "Cannot convert value 'WAL-105221-1' of type Text to type True/False." Maybe Except doesn't play nicely with text values?
