Help creating forecast

[antalva]

I'm looking to create a forecast of number of requests my team completes in a year. I currently only have two months of data to go off for Jan and Feb.

How can I create a forecast based off the below data I have: 

	Number of Requests completed in Jan/Feb	Est annual Occurence	Sum
Monthly Requests	1	12x	12
Quarterly	9	4x	36
Annual	1	1x	1
Adhoc	13	6x	78
			127 annual requests	Forecasted amount

Any help would be greatly appreciated. Thanks so much in advance!

[v-jialongy-msft]

Hi @antalva 

What is your specific forecast plan, if you only currently have data for January and February, how should the data in Quarterly and Annual in your table be presented based on the data for January and February, and what is the Adhoc data in the table based on?

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[antalva]

Hi Jayleny, thanks for your response. Using the data I have for Jan and Feb I'm hoping to get some forecast for the total amount of requests our team will complete this year. We've received 25 requests so far which is reflected on the left hand side of the table along with the frequency that we will continue receiving this year. The only assumption I made was for the adhoc one and that logic is reflected as if we receive 13 in 2 months then we can expect to receive the same amount for the rest of the year which gives a total of 78.

I'm not sure what the best way to present this but I'm hoping that the total shows around 127 annual requests expected to be received this year until we have more data points. Thanks in advance!

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?