Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Help creating forecast

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 b...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

 

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.

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!