Avatar of mikes6058

asked on 

Power Pivot - Can't create relationship - No dublicates???

Attached is an excel document with two tables loaded into a power pivot data model. I am trying to create a relationship between the stock code field in each table. I have used conditional formatting to check for duplicates in the supplier table stock code column and can't find any. Yet when I try and create a relationship I am getting the many-to-many error.

Can anyone double check for me, perhaps I'm missing something.

Microsoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon