Forum Discussion
Solved
Use date slicer to check if date falls between two dates
Hello everyone! I'm working on a report for our historical leasing records. We are trying to check the percentage of unit occupany at any given date. I have columns such as lease start date, leas...
Hi MAlSarhani
You could try a disconnected table for your slicer and use a calculated measure as a filter for your visual.
The calculated measure could look like this. I have attached a PBIX file.
Measure as Filter = VAR SelectedDate = SELECTEDVALUE('Dates'[Date]) RETURN IF(SelectedDate >= MIN('Table1'[Start Date]) && SelectedDate < MAX('Table1'[End Date]),1,0)
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHi MAlSarhani
You could try a disconnected table for your slicer and use a calculated measure as a filter for your visual.
The calculated measure could look like this. I have attached a PBIX file.
Measure as Filter =
VAR SelectedDate = SELECTEDVALUE('Dates'[Date])
RETURN
IF(SelectedDate >= MIN('Table1'[Start Date]) && SelectedDate < MAX('Table1'[End Date]),1,0)