Forecast calculation

[jdevalk]

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

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[jdevalk]

Great, that's exactly what I was looking for.

Much appreciated and thank you very well!

[Ashish_Mathur]

You are welcome.