New to PowerPivot, i just want to know if a VIN is on my joined table

[Jeffrey Green]

I have t two tables containing Bill of Materials (BoM) data for vehicles.
One table is my master table from my Access DB and had 3 millions rows, with the VIN of the vehicles and all of the parts that go into it.

I got a dozen more excel files of BoM data, that I may, or may not, already have in my Access data base.

I brought my 3 million rows into Power Pivot, no problem
I opened up my Excel file with 700,000 rows in Excel, made a linked table and then it get brought into the PowerPivot window, all is good . . . .

Now, i just want to know if the vins on the Excel file are on the table brought in from Access.

In Excel, i might do a countif to see how many BoM parts, if any are in Access.
Or I might use MATCH function to just see if they're there.

What DAX function might i use?? thanks

i can't relate the tables because of the Many to Many relationship

 

[GorD]

I'm no expert, but it doesn't sound like a power pivot job to me ( at least to begin with), as you have nothing to relate the tables.

Are you aware of Power Query -this will allow you to create a single table with all the data rows.

From there either a pivot table or power pivot will allow you to count how many entries you have for each VIN

Hope that helps a bit