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

 

 

 

  • haichenhuang's avatar
    haichenhuang
    Frequent Visitor
    2 years ago

    Because I don't want the slicer to perform as: 

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

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

     

    Rather, I want it to do the following - note how it is different:

    'Work'[Start Date] <= MAX('Calendar'[Date])

     && 'Work'[End Date] >= MIN('Calendar'[Date])