Filtering To date filter using the other From date filter.

[Parul]

I have 2 disconnected date tables and I am creating measures for data between these 2 dates.
If I have one date selected in "From" date slicer I want my "To" date slicer to show dates for next 12 months. (based on From date selection)
However I am unable to achieve the same.

[amitchandak · Accepted solution]

@Parul , if the second one is not a range slicer

Create a measure

measure  =

var _max =maxx(allselected('Date1'), 'Date1'[Date])  //Slicer 1

return

countrows(filter('Date2', 'Date2'[Date]>= _max && 'Date2'[Date] <= eomonth(_max,12)) )

use this in visual level filter and check for "is not blank"