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 below data I have: 

 Number of Requests completed in Jan/FebEst annual OccurenceSum 
Monthly Requests112x12 
Quarterly94x36 
Annual11x1 
Adhoc136x78 
   127 annual requestsForecasted amount


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

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

  • 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!