Rolling 12 month over Dimension in bar chart

[nishika]

I have used this Expression for rolling 12 Month over dimension, and Date field is in YYYY-MM format.

But when on Date selection suppose "2018-10"  then it will give all the values Before 2018-10 instead of only 12 month .

Rangesum(Above(Sum({<Date={">=$(=Date(AddMonths(Max(Date),-11),'YYYY-MM'))<=$(=Max(Date))"}>}[ACT@AR])
,0,RowNo()))

[VaishnaviC · Accepted solution]

hope it helps!

[VaishnaviC]

not able to put  the formula directly, as having issue while posting

[nishika]

Hi Vaishnavi,

Great formula is working 🙂