Forum Discussion

ffunky's avatar
ffunky
Helper I
6 years ago

Q&A Relative date filter stopped working

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.

Need Help

1 Reply

  • v-joesh-msft's avatar
    v-joesh-msft
    Solution Sage
    6 years ago

    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.