Forum Discussion

kukszi's avatar
kukszi
Icon for Helper I rankHelper 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
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

parry2k's avatar
parry2k
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper 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
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      You may download my PBI file from here.

      Hope this helps.

      • kukszi's avatar
        kukszi
        Icon for Helper I rankHelper I
        4 years ago

        This is perfect, thank you very much, Ashish_Mathur!