Subtract 2 columns from different tables

[Anonymous]

Hi guys,

I have two tables:

Table A    (Supplier ID = 1,2,3,4,5,6,7)

Table B     (Supplier ID = 4,5,6)

I would like to filter out Supplier ID in Table B from Table A, so that I have only ID = 1,2,3,7 but I don't know how to go about it.

I'm new to DAX and any help would be appreciated. Thanks!                       

[amitchandak]

@Anonymous 

except

new Table = except(Table1[Supplier Id], Table2[Supplier ID])

https://docs.microsoft.com/en-us/dax/except-function-dax

[Greg_Deckler · Accepted solution]

Table = 

  EXCEPT('TableA'[SupplierID],'TableB[SupplierID])

[Anonymous]

Thanks it worked!