Forum Discussion

bsz412's avatar
bsz412
Helper III
4 years ago

Calendar table strange behavior

Hi,    I have a calendar table created as below:  Calendar = var FullCalendar = ADDCOLUMNS(CALENDAR(MIN(sales_purchase[Date]),MAX(sales_purchase[Date])),"Month Number",MONTH([Date]),"Year",YEAR([...
Need Help
bsz412's avatar
bsz412
Helper III
4 years ago

I have the same issue with a different calendar table as well 😞 I found out that the root of the issue is that the date hierarchy does not react to the date slicer. How could I fix that? johnt75 HotChilli 

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    Try creating a proper date table instead of using the built-in one. You can use the code you have already but get rid of the SUMMARIZE, you want to return the full table. When you've created it, you can right-click on it and choose "Mark as date table". You'll then be able to create your own date hierarchy which should solve your problems