DAX formula or PowerPivot connection?


Board Regular
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?

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...