Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

Calendar generation BUG

Why calendar generates wrong dates?

tbl_PL[EndOfMonth] have maximum date 2020-09-30

 

But this measure generates good dates, but slicer show wrong dates until 2020-12-31 instead of 2020-09-30

 

Calendar =
CALENDAR (
MIN(tbl_PL[EndOfMonth]),
MAX(tbl_PL[EndOfMonth])
)
 
and result is same like this
 
Date = CALENDAR (
DATE ( MIN(tbl_PL[Year]), 1, 1),
DATE ( MAX(tbl_PL[Year]), 12, 31)
)
 
 

 

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • v-robertq-msft's avatar
    v-robertq-msft
    Community Support
    5 years ago

    Hi, Analitika 

    According to your description and picture, I created the data and measure and Slicer similar to yours, and I can also find this issue, I guess the reason is that you put the Date Hierarchy into the Slicer, if you change it to the origin [Date] column, it will be correct:

     

    What’s more, for Date range Slicer, we usually use “Between” mode so that Date can be filtered intuitional. Here a blog explains why this issue happens some time, you can take a look:

    https://blog.crossjoin.co.uk/2019/07/10/power-bi-slicers-show-values-that-do-not-exist/

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Analitika's avatar
      Analitika
      Post Prodigy
      5 years ago

      But i need hierarchy as it will not be slicer anymore without hierarchy