Calculation of average

[Polite123]

Hi Team,

Need some quick analysis for the below data in averaging.Please suggest

Example:

I am running data for April month which should be average of above three months as shown below(Actually April data is not available...we have data till march).

Months	Value
Jan	2
Feb	3
Mar	4
April	3

Now when I run data for May month(which is actually not there)...it should be average of above 4 Months as shown below(April data is now made available):

Months	Value
Jan	2
Feb	3
Mar	4
April	6
May	3.75

Similarly when I run data for June month,it should be simply average of above 5 months as shown(May data is now made available):

Months	Value
Jan	2
Feb	3
Mar	4
April	6
May	7
June	4.4

Thanks in advance:)

[Harbinger]

@Polite123 my solution should be dynamic and simple.