Forum Discussion
Anonymous
6 years agoNot applicable
Subtract 2 columns from different tables
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!
Table =
EXCEPT('TableA'[SupplierID],'TableB[SupplierID])
3 Replies
- Greg_Deckler
Community Champion
Table =
EXCEPT('TableA'[SupplierID],'TableB[SupplierID])
- AnonymousNot applicable
Thanks it worked!
- amitchandak
Super User
Anonymous
except
new Table = except(Table1[Supplier Id], Table2[Supplier ID])