Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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/
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |