Future 12 months of 6 months moving average

[Anonymous]

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!