Set analysis- Sum current date vs 11 previous months with YearMonth dimension

[vhespinog]

Hello,

I need to create a bar chart with YearMonth Dimension. The expression = current month + 11 previous months

I'm using this set:

=sum({$<YearMonth={">=$(=MonthStart(Max(YearMonth),-11))<=$(=MonthEnd(Max(YearMonth)))"},Year=,Month=>}Sales)

if I put it in a textBox with one YearMonth selected  works but in my graph doesn't

The test dats is attached

Thanks in advance

[sunny_talwar · Accepted solution]

Are you looking to get this?

[vhespinog]

Thank you!, works fine