Forum Discussion

Hammarberg's avatar
Hammarberg
Frequent Visitor
9 years ago

How to calculate Forecast accuracy

                      Hi,   I've been trying to get my head around how to calculate a forecast accuracy. Here is how I usually set up a simply formula in excel:   First I calcula...
Need Help
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

Hammarberg

If you want a MEASURE instead of COLUMN use this the SUMX function is an iterator

ABS Variance MEASURE = SUMX('Table', ABS('Table'[Forecast] - 'Table'[Sold]) )

Accuracy MEASURE = 1 - ( [ABS Variance MEASURE] / SUM('Table'[Forecast] ) )

This works with the first example you posted! (You can filter the 'Table' in the SUMX if necessary...)

To get anyone to help you further if this Measure doesn't help you with you actual data

Post sample data that can be copied and pasted into PBI not images!

Otherwise you are asking people to spend the time to recreate your data in order to test it and many will skip over your question

Hammarberg's avatar
Hammarberg
Frequent Visitor
9 years ago

Hi Sean,

 

The solution you had for ONE table works perfectly. I've tried some different approaches but hit a dead end. Attached you find a bigger excel sample file and a pbix. If you would be ready to have a look it would be greatly appreciated.

 

Example.xlsx

Sample.pbix

 

Let me know if there is any issues with the links (did not see how to upload files directly to the message).