Fixed date range chart slider overiding report level filter

[Analitika]

I have chart column 

CALCULATE([Profit],DATESINPERIOD('Date'[Date],LASTDATE('Date'[Date]),-12,MONTH) )

I need report level on dates to show other chart in two years ranges.

I need overide report level filter for get whole dates ranges for two charts wich display datesinperiod.

I need to spin (slide) this datesinperiod by one month in all dates ranges

How to do that?

[amitchandak · Accepted solution]

@Analitika , Dateinperiod will create rolling , try like

Measure =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = date(year(_max)-2,month(_max),day(_max))
return
calculate([measure],filter(All(DATE), Date[Date] >=_min && Date[Date] <=_max))

or
Measure =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = date(year(_max)-2,1,1)
return
calculate([measure],filter(All(DATE), Date[Date] >=_min && Date[Date] <=_max))