Forum Discussion

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago
Solved

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.

 

 

  • Hi jdbuchanan71 ,

     

    Microsoft reply: bug filed internally, core issue identified.

     

     

    Best Regards,

    Icey

10 Replies