Relative date slicer bug? - Last X Month ignoring first date

[jdbuchanan71]

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.

[Icey · Accepted solution]

Hi @jdbuchanan71 ,

Microsoft reply: bug filed internally, core issue identified.

Best Regards,

Icey

[Icey]

Hi @jdbuchanan71 ,

This issue has been reported internally. I will update the progress in time.

Best Regards,

Icey

[jdbuchanan71]

Thank you for the update @Icey .  Also, here is a link to the issue I submitted on this item.

https://community.powerbi.com/t5/Issues/Relative-Date-slicer-Last-X-Months-drops-first-date/idc-p/14...

[jdbuchanan71]

Here is a better illustration just using MIN ( Dates[Date] )

[PaulDBrown]

@jdbuchanan71 

It sure does look like a bug...does it happen for every month?

[jdbuchanan71]

It seems to, yes.  No matter how many X months you select it always drops the first date.

[dedelman_clng]

There are some values where it works "properly", For Sept (30 day month), if you go back to July (3), May (5), March (7), December (10), or October (12) it works OK.

[jdbuchanan71]

@dedelman_clng 

I thought it might be that if the month you rolled back to had 30 days then the display would step back a day but then last 2 would not break because August has 31 days and it still rolls back to 7/31/2020.

It looks to be a descrepancy between the reported filter (the one on the bottom of the date slicer and in the filter tool tip on the cards) and the real filter (the one applied in the model).

[PaulDBrown]

@jdbuchanan71 

How about if you select a mid-month date as your final date for the period (instead of the last day of a month)? (Apologies, since I'm not at a computer so can't try myself)

[jdbuchanan71]

Any other type of date filtering seems to work.  It is only the Relative Date using Last X Months where I have seen this problem.