Forum Discussion
KushGupta123
3 years agoFrequent Visitor
Subtracting two tables
I have a table "Supplier_Entity" and it has two colums Seller_id and Supplier_Name, there is this another table out_of_network_suppliers having same columns. Supplier_Entity= out_of_network_suppliers+ in_network_suppliers. "in_network_supplier" is not a table, how do I get the data for in_network_supplier. Basically how do I remove the out_of_network_suppliers data from Supplier_entity in order to get desired data.
1 Reply
- v-easonf-msftCommunity Support
Hi, KushGupta123
You are referring to returning the rows of the first table in the expression which do not appear in the second table,
please try table manipulation functions 'EXCEPT'.
https://learn.microsoft.com/en-us/dax/except-function-dax
Best Regards,
Community Support Team _ Eason