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...
Hi Milagros ,
Try EXCEPT() function.
https://docs.microsoft.com/en-us/dax/except-function-dax
Table = EXCEPT('Table a','Table b')
Best Regards,
Jay
Hi Jay, Thanks, I tried that, but got this message "Each table argument of 'EXCEPT' must have the same number of columns." I should mention that my tables have other columns in them and they don't have the same number of columns.
Kind regards, Mila
