This is the formula of the ratio:
[Measures].[Story ratio] =
[Measures].[Days spent by <rep. devs> on Stories]/
[Measures].[Days spent by <rep. devs>]
The moving average of [Story ratio] might be something like:
[Measures].[Story ratio, ma.] =
Avg(
[Time].CurrentHierarchyMember.Lag(5):
[Time].CurrentHierarchyMember.Lag(1),
[Measures].[Story ratio])
So what I would like is, referring to the screenshot: the moving average value of [Story ratio] (calculated based on week 9, 8, 7, 6 and 5) is projected into W10 -> W19.
In the screenshot example W19 is the last week, but that could be any week in the future (depending on the number of rows in the Google Sheet).