Forum Discussion

rob_mysbxsec's avatar
rob_mysbxsec
Helper II
5 years ago
Solved

using date function in report page filter comparison

Is there anyway for this kind of report page filter to use one of the date functions noted, UTCTODAY or UTCNOW, instead of a statically selected date?    
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    rob_mysbxsec , Typically we create a flag like this and use that in slicer , So now you can use today as filter

     

    new column in date table

     

    Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")

     

    Is Today = if('Date'[Date]=TODAY(),"Today",format([Date],"YYYYMMDD"))

     

    or

    Is less than Today = if('Date'[Date]<=TODAY(),1,0)

     

    Check : https://www.youtube.com/watch?v=hfn05preQYA

amitchandak's avatar
amitchandak
Super User
5 years ago

rob_mysbxsec , Typically we create a flag like this and use that in slicer , So now you can use today as filter

 

new column in date table

 

Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")

 

Is Today = if('Date'[Date]=TODAY(),"Today",format([Date],"YYYYMMDD"))

 

or

Is less than Today = if('Date'[Date]<=TODAY(),1,0)

 

Check : https://www.youtube.com/watch?v=hfn05preQYA

rob_mysbxsec's avatar
rob_mysbxsec
Helper II
5 years ago

Like this game plan.  Any reason you propose use of a Slicer vs a report page or visual filter setting to filter by these computed Column date values that contain Today, Yesterday, This Month special values?