Q&A Relative date filter stopped working

[ffunky]

Hi all,

For some reason, this week my Q&A testing shows that I cannot use relative date filtering (ie last week, last 4 weeks, last month).  I can get results when I ask for December, or 2019, etc.  Just not relative to today.  I haven't changed anything in my model that I can think of.  My date field is a valid date formatted field through the end of 2020 and the table is makred as a date table.

Anything I can try?  I get this error:  

The filter on '_CAL_DT'[CAL_DT] is not valid. Check that the data type of the '_CAL_DT'[CAL_DT] field matches the filter you're trying to apply.

[v-joesh-msft]

Hi @ffunky ,

I would suggest you check the field ‘_CAL_DT '[CAL_DT] again. To use Relative Date filtering, your column must be formatted as Date or Date/time. To check, click on the column and then select 'Column tools' from the menu bar. Under 'Data Type' make sure the format is either Date/time or Date.

If not your case, please share your sample pbix file for us to have a test. Please upload your files to One Drive and share the link here.

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.