Forum Discussion

successken's avatar
successken
Regular Visitor
10 years ago

Today Filter in Reports

I'm not if I'm missing this. Is it possible to create gauge reports and such with a date filter of Today or Yesterday without utilizing the Q&A?   My goal is to have a quick dashboard reference on ...
austinsense's avatar
austinsense
Icon for Impactful Individual rankImpactful Individual
10 years ago

You could create calculated columns on the date table ...

 

TODAY FLAG = IF( Date[Date] = NOW(),1,0)
YESTERDAY FLAG = IF( Date[Date] = NOW()-1,1,0)

and then use those as filters on the page or visualization.

 

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

A [Days from Today] column in a Date Dimension works especially well in Power BI.  You can DATEDIFF against today to allow users to filter on a rolling range of dates.