Comparing actuals with budget

Hi,

I am having some difficulty here and wondered if the community could help!

I have actual Headcount data which includes name, vacancy etc. but critically their start and, if applicable, end date. I have also got an expanded table which takes the start and end dates and expands them. This is so as to get an historical perspective to see who was employed at a particular date and time. I get a nice timeline line graph for that.

I would like to compare this against budget. The difficulty I am finding is that the budget date on the budget spreadsheet I have has a full date (29 February 2020 for instance) and fails to match adequately to the correct start date on here. This is likely due to the fact that the budget is taken at the month end and hence would be a step function over a month by month basis rather than a day-by-day basis which the actual headcount is. 

Essentially I want to be able to compare actuals vs budget but now and in the past on a chart and in visuals with the difficulty being that the dates for one are a daily basis and the dates for the other are only done at month end and do not match correctly. Not sure what I'm doing with the relationships that needs tweaking or with the data itself.