Power Pivot Date Join

Craigc3814

Board Regular
Joined
Mar 7, 2016
Messages
217
I have 3 tables,

One is a workorder table that has the due date of some 300 workorders (obviously dates are repeated)

Second table is a supervisor table for dates that supervisors worked (again repeated dates)

Third table is a calendar table I created through PowerPivot

I am trying to merge the workorder table and the supervisor table through the use of the date table

When I make a pivot table I select the date from the Calendar table, I think select supervisor name from the supervisor table

Instead of just showing me dates that the supervisors worked it is showing me every date that is in the calendar table and every single supervisor that has ever worked is repeated under the date.

I have been trying to figure this out, I know the date formats are the same because I can run a DAX lookup formula and it will pull information over (creates an error that dates are repeating when I add multiple supervisors on the same day)

PLEASE HELP
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top