Forum Discussion
Relative date slicer bug? - Last X Month ignoring first date
I wanted to verify that others are seeing the same behavior I am.
When using a relative date filter and the Last X Months option, the first date in the range is being left out.
I put together a simple model to show the issue. You can see that I do have data for 8/31/2020:
However, when selecting Last 1 Months, even though the date range is listed as 8/31/2020 - 9/30/2020 the amount for the date 8/31/2020 is left out:
This also appears to only be the case when using the Month selection. Last X Weeks or Last X Years include the first date:
I also tested with a couple of cards where each date slicer only applies to the card next to it. The Between setting is fine and the first date is included in the calculations.
I have attached my sample for others to look at.
10 Replies
- Icey
Community Support
Hi jdbuchanan71 ,
This issue has been reported internally. I will update the progress in time.
Best Regards,
Icey
- jdbuchanan71
Super User
Thank you for the update Icey . Also, here is a link to the issue I submitted on this item.
- jdbuchanan71
Super User
Here is a better illustration just using MIN ( Dates[Date] )
- PaulDBrown
Community Champion
It sure does look like a bug...does it happen for every month?
- jdbuchanan71
Super User
It seems to, yes. No matter how many X months you select it always drops the first date.
- Icey
Community Support