Forecast calculation

Hi, I'm quite new into DAX so therefore I can use some help on forecasting.

Based on sales budget and forecast, I would like to calculated the needed hours for the next 2 months based on historical data.

So I would like to calculate the red marked cells in the excel example. The table without the last 2 columns is attached.

Who can support me in here? Thanks in advance.

Jurgen

Excel file

PBIX