set for rolling 12 months?

Anonymous — Mon, 30 Mar 2015 16:26:50 GMT

=Sum({<date ={">$(Date(=AddMonths(max(date),-12)))<=$(Date(=AddMonths(max(date),-1)))"} >}[budget amount])

here date is dimension

date:

1/1/2013

1/1/2014

2/1/2014

1/1/2015

1/2/2015

but it showing from 1/1/2013 why like this

pls correct me ?

Re: set for rolling 12 months?

Mon, 30 Mar 2015 19:09:51 GMT

Hello,

Didn't try out but seems the equal sign is missplaced.

=Sum({<date ={">$(=Date(AddMonths(max(date),-12)))<=$(=Date(AddMonths(max(date),-1)))"} >}[budget amount])