using date function in report page filter comparison

[rob_mysbxsec]

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?

[amitchandak · Accepted solution]

@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]

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?