Forum Discussion

haichenhuang's avatar
haichenhuang
Frequent Visitor
2 years ago

Date range filter slow performance

Hi there, I want to filter based on date ranges according to this logic:   'Work'[Start Date] <= MAX('Calendar'[Date])  && 'Work'[End Date] >= MIN('Calendar'[Date])   Originally using a date be...
Need Help
Tips and Tricks
olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi, why the original slicer didnt work?

in you original confition, it has to be 

'Work'[Start Date] >=Min('Calendar'[Date])

 && 'Work'[End Date] <= Max('Calendar'[Date])