Forum Discussion

JLeflaive's avatar
JLeflaive
New Member
2 years ago
Solved

Relative date filter for month to date

I need to have a relative filter for a report that filters for all dates in the current month but excluding anything after yesterday.   The Current Month filter does not work because it includes da...
Need Help
  • djurecic's avatar
    djurecic
    2 years ago

    Hi JLeflaive ,

     Are you using a date table? If so, you can try creating a column like IsYesterdayorBefore and filtering the report or visual on this field where this field is true. Use this filter in conjunction with the relative data slicer.

     

    Something like this:

     

    IsYesterdayorBefore =
    var YesterdaysDate= TODAY()-1
    return
    IF(Dates[Date]<=YesterdaysDate,True, False)
djurecic's avatar
djurecic
Super User
2 years ago

Hi JLeflaive ,

 Are you using a date table? If so, you can try creating a column like IsYesterdayorBefore and filtering the report or visual on this field where this field is true. Use this filter in conjunction with the relative data slicer.

 

Something like this:

 

IsYesterdayorBefore =
var YesterdaysDate= TODAY()-1
return
IF(Dates[Date]<=YesterdaysDate,True, False)
JLeflaive's avatar
JLeflaive
New Member
2 years ago
Thanks, that works!