Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Fixed date range chart slider overiding report level filter

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?
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    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))

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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))