Showing results for 
Search instead for 
Did you mean: 
win_toeknee Member

Automating Report Level Date Filter to TODAY

Is there a way for me to have a report date filter update to reflect TODAY automatically? 


I currently have to manually select today's date but if there is a way for it to update automatically, it will be a great help. 


Reason I have to put a filter is because the data that I have changes daily and there are forcasted data that will throw off my model. 



Super User
Super User

Re: Automating Report Level Date Filter to TODAY

Many people create a calculated columns or measures to calculate the days between TODAY and a date column in your fact table. Then you can set the filter to equal 0 and you will always have today essentially.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!