Connect Data Sources that are Structure Differently

Hi,

I have two different tables, one that has timesheet information and one that has forecast information.  The Timesheet information may have some negative hours and some may have multiple entries for a single day (if that makes a difference).  The forecast information is static and is on a monthly basis, this can be split out on a pro-rata based on working days which could help.  Ultimately I need a single table that shows Actuals vs Forecast across a date set by a date slicer.

Anyone got any ideas?

Sarah