I have two tables one that shows all of my work order data and a column called due dates that a user manually updates to assign due dates to a given work order.

I have another table called supervisor that has dates that supervisors worked, and any comments they may have added to the table. There are multiple supervisors that work on the same day so one column is dates, next is supervisor name, then a column that indicates the shift that they worked (A.B, or C)

I want to join the two tables so that I know what supervisor oversaw the work that was completed during his shift and work day.

I cannot figure this out for the life of me and I know it should be a very simple solution

I created a calendar table in PowerPivot then tried joining the date from the calendar table to the date on the supervisor table and the date on the work order table

The connection does not work when I create a pivot table then add the calendar table date followed by any information from either table it brings it all of the information, not just the information where the dates match.

I checked to make sure the dates were formatted the same and that was not the issue.


Is this better solved another way?