Forum Discussion
Setting Relative Start and End Dates with Between type Date Slicer
Thanks. This works -- only as long as you do not accidentally select a date from the dropdown calendar (as I might do to test) and then save the report. Once you select a date from the calendar drpdown in the slicer it ignores the formula and caches the value you selected. The only solution I have found is to recreate the slicer from scratch and not pick a date. This is a caveated solution. Thanks.
Hi pritzlb,
Based on my test, I made an sample for your reference.
You can create a filter column using the formula.
filter = IF(cal[date]<=TODAY()-1 &&cal[date]>=TODAY()-30,cal[date],BLANK())
Then you can get the result as you need.
For more details, please check the pbix as attached.
Regards,
Frank
Thanks. This works -- only as long as you do not accidentally select a date from the dropdown calendar (as I might do to test) and then save the report. Once you select a date from the calendar drpdown in the slicer it ignores the formula and caches the value you selected. The only solution I have found is to recreate the slicer from scratch and not pick a date. This is a caveated solution. Thanks.