Query Help - Display Whats Not In

[Centaur]

Hello,

I have an excel file.

Data in 2 sheets (table1 and table2)  

I want to show what data from sheet 2 that is NOT IN the first sheet (table1)

Criteria:  Co Name and Inv No and Amount (must be on all 3 criteria). 

How could I do this? 

Please see link below to the file in my OneDrive.

I dont see how I can upload files to this website. 

https://1drv.ms/x/s!AkvCjNvcBhpQiPRKD17-FvTk_Tkv-g?e=q47pdI

thank you

[Centaur]

Hello, thank you 

Could you please paste the codes? 

thank you very much. Or the excel? 

[Anonymous · Accepted solution]

Hi @Centaur 

It is from the GUI, click the button in yellow, and see different ways to join tables, original excel files with queries attached

[Centaur]

Nice.  I thank you very much for the help.  Have a good day. 

[Anonymous]

Hi @Centaur 

.pbix file attached

[Centaur]

Hi Vera,

Could you kindly save it as a regular file?   I do not have Power BI and I do not have any experience with it.  I only use excel and power query.  I looked online on how to open pbix file in excel and it seems I can not do this.  Sorry for being less than tech savvy.  

[Anonymous]

Hi @Centaur 

Left anti join should be working?