Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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/
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |