Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Relative Date Last 1 Calendar Month Not Working

I have found this morning that my date slicer that is set to Last 1 Calendar Month is no longer working. I have a Date table and it is using a Min and Max value of a tables timestamp column which is date only, no time values.

At the time of this post it was 01/12/2022 (dd/mm/yyyy). So the slicer should be showing a date range of 01/11/2022 - 30/11/2022 (dd/mm/yyyy)

If I choose This Month it shows the correct date range (November).

While typing this post I refreshed the BI file and it has now changed to the correct date range since 11.00am. So it is using UTC time. I'm in Australia with daylight savings at the moment.

I haven't seen this issue before and was wondering if there may have been an update to BI Desktop in the background recently that has caused the issue?



Super User
Super User

@MarkWill , Power bi November 2022 update is released, if you see teal(green) color on startup screen or on + button, then it nov release.


you can issue at

Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

Thanks for replying amitchandak. I do have the teal startup screen. 

I have pasted my post in the issues page.


Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.