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 s...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi jdbuchanan71 ,

     

    Microsoft reply: bug filed internally, core issue identified.

     

     

    Best Regards,

    Icey

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

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

 

 

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    5 years ago

    jdbuchanan71 

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

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

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

       

      • PaulDBrown's avatar
        PaulDBrown
        Icon for Community Champion rankCommunity Champion
        5 years ago

        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)