Problem with set analysis restricting months

[#1]

I have a Set Analysis showing the last 3 months according to what the user selected month, if I select October, the chart shows

data for July, August and September, the correct is August, Setember and October. Follows the current formula:

num( Sum({$<Calendar.Month={'>=$(=max(Calendar.Month-3))<=$(=max(Calendar.Month))'} Table.Value) '#.##0M')

[#2]

hi

for previous 3 month data try this

sum({<Datefieldname={">=$(=monthstart(max(Datefieldname),-3))<=$(=monthend(max(datefieldname),-1))"}, year=,month=>}TableValue)

[#3 · Accepted solution]

or try this

num( Sum({$<Calendar.Month={'>=$(=max(Calendar.Month-2))<=$(=max(Calendar.Month+1))'} Table.Value) '#.##0M')