Forum Discussion
Date Filter range
Hello Guys,
Im wondering how can I set my date dilter to be uptodate?
I mean date filter range =start date to end date. I would like that the end date will change automaticly (not manually) to today.
I normally write a calculated column using an if statement. Eg
=if(calendar[date]=today(),"Today",calendar[date])
this new column will Update on every refresh. Any filter on "Today" will stick and the date will change. Another approach is to use Power Query to load a calendar that grows as I describe here https://powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/
1 Reply
I normally write a calculated column using an if statement. Eg
=if(calendar[date]=today(),"Today",calendar[date])
this new column will Update on every refresh. Any filter on "Today" will stick and the date will change. Another approach is to use Power Query to load a calendar that grows as I describe here https://powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/