Solved: Re: Forecast calculation

Anonymous · ‎04-08-2022

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

Ashish_Mathur · ‎04-09-2022

Hi,

You may download my PBI file from here.

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Ashish_Mathur · ‎04-09-2022

Hi,

You may download my PBI file from here.

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Anonymous · ‎04-09-2022

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

Much appreciated and thank you very well!

Ashish_Mathur · ‎04-09-2022

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Forecast calculation