Refresh Pivot - Many to One Relationship Problem

[Chris1976]

Hi There

I have a pivot chart that is connected to 2 data tables. I created a individual table with dates in YEARS to be able to create a relationship (many to one) between the two main data tables (with power query I think it was). I did this because I use one slicer on a Dashboard to control the Date selection of both tables. Here is the error I received when a refreshed the pivot tables.

Pivot Table Error.JPG

The error generated because it says that i have duplicates dates in my audit summary table. Here is what i find weird.

In my second data table called Finding Summary Table there are many dates with the same date as 07/10/2020(see below image) but when I refresh the table (after lets say changing the duplicate date of the Audit Summary Table to 08/10/2020) then it refreshes perfectly

Why is it doing that - Please ignore the last image, i was unable to remove it once uploaded

Pivot table 2.JPG