Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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:

danextian's avatar
danextian
Icon for Super User rankSuper User
3 years ago

hi , 

I don't get why you're using DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), DAY ( TODAY () ) ) instead of simply TODAY ().

Anonymous

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Because I didn't know you could do that when I started this dashboard and left it as-is.