Sum(Value) for last 12 months having only YearMonth

[Alessandro_TZ9]

Hello,

What is the best formula to add the values of the last 12 months having only Year and Month in the yyyymm format?

Thanks for helping

[steeefan · Accepted solution]

Try this: Sum({<Calendar.YearMonth = {">=$(=Date(MonthStart(AddMonths(Today(), -11)), 'YYYYMM'))<=$(=Date(MonthEnd(Today()), 'YYYYMM'))"}>} Value)

You might have to adjust the field name where your YearMonth values are stored. Here I'm using Calendar.YearMonth.