Forum Discussion

rai9micm's avatar
rai9micm
Regular Visitor
3 years ago

Help with ambiguous behavior Relative Date in Filter Pane

My database contains data that is updated everyday. Client needs two report pages: one with the data of "Today", and another one containing historical series data.   For the "Today" page, I'm filte...
Need Help
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

You could, for example, add a page filter from the Filters panel with CreationDate, select a filter of type "Relative Date" and set it to show only items that are in the last "1" day, by selecting the "Include today" box.

Another longer solution could be to create specific measures for the page today, including a CALCULATE FILTER of the type CreationDate >= TODAY().

rai9micm's avatar
rai9micm
Regular Visitor
3 years ago

Thanks for replying! The first option you described is exactly what I'm doing haha. I really want to keep it that way but I'm facing the issue of it considering "another day" after around 10pm. 

 

If I can't find a solution here I'll just create a new column in the view that PBI is extracting the data from the database, flagging it as 1 if it's today.

 

Btw, I'm in the GMT-4 time-zone.