Forum Discussion
Limited calendar with an IF statement
I have a dashboard that is navigable through a movable slicer set on Between that has a calendar in it. The formula I've set for it is: Calendar = CALENDAR(DATE(2021,1,10),DATE(YEAR(TODAY()),MON...
hi Anonymous
it seems the up limit of the calendar table shall be aligned with data record.
try like:
Calendar = CALENDAR( DATE(2022, 1, 10), MAX(RecordTable[Date]))
try like:
FreemanZ
Super User
Super Userhi Anonymous
it seems the up limit of the calendar table shall be aligned with data record.
try like:
Calendar = CALENDAR( DATE(2022, 1, 10), MAX(RecordTable[Date]))
try like:
Nice trick! I didn't know you could do that. Thanks for the help!