Power pivot or power query question - differences between linked tables?

[PoetStorm]

Hi there, new to the power tools and trying so hard to learn.

I have two excel tables that I have added to my data model and want to be able to extract the detail if it's in one table and not the other.

Basically I have an inventory table containing all charts each one with a unique ChartID. I then have another table containing only billed / invoices charts also with unique ChartIDs, rates, invoice#s etc.

What I want to do is see the charts on the inventory table that are NOT billed. So far I can only pivot and show what is in both tables. I created a relation between the two tables using the unique Chart ID field.

Can someone give me some guidance? Should I use power pivot, power query, or something else? How could I go about doing this. The reason is that our volumes are nearing over a million rows and growing though I expect it to not exceed 2 million, so I really cannot manage it in excel alone much longer. I was hoping loading them to a data model was going to help me manage the large volume and easily see what I have not billed for yet.

Really appreciate any help. Thanks.

Laura

 

[GraH]

Try the anti join on Power Query (Google to the rescue, plenty of tutorials out there)

 

[PoetStorm]

Try the anti join on Power Query (Google to the rescue, plenty of tutorials out there)

Ah thank you! I shall try that tomorrow. Helps to Google the correct terminology. Thanks so much.