Forum Discussion
Solved
Date range filter based on dates between two date fields
I have two tables. Date Table and Schedule. They are related by 'Date'[Date] and "Schedule'[Date Scedule Start]. I also have an inactive relationship between 'Date'[Date] and 'Schedule'[Date Schedule...
Hi,
I have solved a similar question in the attached file.
Hope this helps.
Measure=
Var DateRange= values( date[date] )
Var rowsinrange =
Calculate(
Countrows( schedule ),
Removefilters( date )
Schedule[date schedule start] in DateRange || schedule[date schedule end] in DateRange
)
Return
If( Rowsinrange > 0, 1)
Add this to the visual filters in the filter pane and filter to is not blank