Forum Discussion

bsz412's avatar
bsz412
Icon for Helper III rankHelper 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
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

I think there's a conflict between the calendar table and the auto-created date table.  There is no Month table in the created table but it appears in the field well for Axis.  Click on the Year-MonthName caret and see if it lets you pick your hierarchy.