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.

 

successken's avatar
successken
Regular Visitor
10 years ago

Thank you. I took your idea and applied it in Power Query with 

 

if Date.IsInCurrentDay([Date]) then "Today"

else if Date.IsInPreviousDay([Date]) then "Yesterday"

else ""