In Power BI, I have two tables and I need to generate a new table that includes only the records from table 1 that not match with any record in table 2
Customer Table
![filtering out records that don't exist in another table in Power bi](https://debug.to/?qa=blob&qa_blobid=3645047671202251769)
Sales Table
![power bi find all ids not in other tables](https://debug.to/?qa=blob&qa_blobid=9313962204270595540)
The difference Table should have the records in Table 1 Not in Table 2
How can I get the difference table between two tables in Power BI?