Rolling Twelve Months for Previous Month

[NickHoff]

Currently I have a rolling 12 months total using the following:

=NUM(AVG({$<CalendarYear =, CalendarMonthName =,AddedOn={">=$(=addmonths(max(AddedOn),-12))  <=$(=max(AddedOn))"}>}  MonthlyTargetValue),'##')

I'd like to get the rolling twelve months from the previous month not the current month.

[ramoncova06 · Accepted solution]

it depends on how you date

=NUM(AVG({$<CalendarYear =, CalendarMonthName =,AddedOn={">=$(=addmonths(max(AddedOn),-12))  <=$(=monthend(max(AddedOn),-1))"}>}  MonthlyTargetValue),'##')

[NickHoff]

monthend did it, thank you