Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Noak
Helper IV
Helper IV

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

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.

View solution in original post

1 REPLY 1

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.