Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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 ?
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])