Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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!