Forum Discussion

kukszi's avatar
kukszi
Helper I
3 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.

kukszi's avatar
kukszi
Helper I
3 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.