Rolling 4 Week Forecast Accuracy

[Anonymous]

How could I create a measure for a rolling 4 week forecast accuracy. I have Bookings and Forecast in seperate tables. I got total using

Total Abs Var = ABS(SUM('Trailing 6-month Bookings'[Bookings Value]) - SUM('Weekly Forecast'[Forecast Value]))

and

Total Forecast = 1 - ('Weekly Forecast'[Total Abs Var] / SUM('Weekly Forecast'[Forecast Value]))

My weeks are formatted as 201901, 201902, . . . , 201922, etc.

Can't be hard coded as new data will be coming in for bookins each week and forecast each year. Thanks for any help!

[v-yuta-msft]

@Anonymous ,

Could you please share some sample data and give the expected result?

Regards,

Jimmy Tao