Calendar generation BUG

[Analitika]

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)

)

[v-robertq-msft]

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]

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