Shifting planning by amount of time

[x-File]

Hi all,

I'd like to see what happens in our planning when some reseachr shift in what it will do to our occupancy.

So, for example, if research X gets delayed by 2 months, the values of 24 and 65 in jan and feb will shift 2 months, and

what will the occupancy look like. I've tried this with a measure like 

Shifted = CALCULATE(SUM(Beds[Totaal]), DATEADD('Date Table'[Date], 2, MONTH)), and plot a same bar chart on the right, but that only shows up until november '23 which is weird. So, is it possible to plot this correctly?

Thanks in advance!  Note: I'd like to share my pbix file or the data behind it with you here on the forum, however, I can not share it on here for for a reason (doesn't show that button), so I'd have to PM or email you.

Regards,

Felix

[lbendlin]

Your calendar table has to be both contiguous and covering, including the result of the time intelligence function.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523