I tried to calculate future rolling average, but all I've succeded is the rolling average of current data.
Every month I will have data until month-1, at article and customer level.
I need a measure to calculate every month the next 12 months like this:
Now we are in February23 (with data until Jan23) and I need next 12 months: Feb23-Feb24
For Feb23 = Average(Aug22-Jan23)
For Mar23 = Average of (Calculated Feb23 and Sep22-Jan23)
For May23 = Average of (Calculated Feb23 and Mar23 with Oct22-Jan23)
...
For Aug23 = Average of (Calculated Feb23-Jul23)
For Sep24 = Average of (Calculated Mar23-Aug23)
...
In the next month (Mar23) I will have data until Feb23 and I will need next 12 months Mar23-Mar24
For Mar23 = Average (Sep22-Feb23)
For Apr23 = Average of (Calculated Mar23 and Oct22-Feb23)
For May23 = Average of (Calculated Mar23-Apr23 and Nov22-Feb23)
...
For Sep23 = Average of (Calulated Mar23-Aug23)
For Oct23 = Average of (Calulated Apr23-Sep23)
Any Idea? Thank you!
