Solved: Re: Date Filter range

Noak · ‎10-17-2017

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.

BR,
Noa.

MattAllington · ‎10-17-2017

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/

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

MattAllington · ‎10-17-2017

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/

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.