cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Noak Member
Member

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.

BR,
Noa.
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Date Filter range

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 a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
1 REPLY 1
Super User
Super User

Re: Date Filter range

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 a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.