Forum Discussion

kukszi's avatar
kukszi
Helper I
4 years ago
Solved

Calculating Forecasting Accuracy

Hi there,   I am doing a rolling sales forecast every month, and I would like to measure the accuracy of my previous forecasts. What I would like to achieve is the following: currently, we are in t...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

parry2k's avatar
parry2k
Super User
4 years ago

kukszi the number in your example doesn't match with the pbix file, for 2022.06, the total for product A 1493.26, where you are getting all these 160.66 and 175.43 numbers?

kukszi's avatar
kukszi
Helper I
4 years ago

Hi parry2k ,

 

Thanks for looking into my file. You are right, the full-year number is 1,493.26 units in the June forecasting cycle, but what I'm interested in is the July number from the June forecasting cycle (forecast before the period) and the July number from the August forecasting cycle (when it is already actualized). See the highlighted values on the below screenshot:

 

Thanks,

kukszi

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

    • kukszi's avatar
      kukszi
      Helper I
      3 years ago

      This is perfect, thank you very much, Ashish_Mathur!

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        3 years ago

        You are welcome.

    • Cheers01's avatar
      Cheers01
      New Member
      2 years ago

      Hello Ashish,

       

      Good day! Possible to share the solution again? I have similar issues and am hoping to find a solution to calculate forecast accuracy.

       

      Thank you

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        2 years ago

        Hi,

        I do not have that file,  Share some data to work with, explain the question and show the expected result.