Forum Discussion
Calculate MAPE based on Absolute Percentage Error
Hi there We have a requirment to use statistics to show the MAPE for a user on how well their Electricity Usage correlates with the Moving Average of what we estimate they should use. To get ...
You can use the Hasonevalue function:
IF(HASONEVALUE('table'[date]),
DIVIDE(
ABS(AVERAGE('table'[actual]) - AVERAGE('table'[predicted])),
AVERAGE('table'[actual]))
*100
,
AVERAGEX('table',
DIVIDE(
ABS('table'[actual]) - table'[predicted]),
'table'[actual])
*100
))