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:

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I mean, yes, I could do that. In fact it's what I'm using right now on my dashboard.

 

 

What I want to do is to make it so when 2024 arrives, I don't have to make a patch that my boss has to download so they don't get confused about why 2024 is selectable when there's no data available. Today there was a bit of confusion surrounding 2023 in the 2022 dashboard, which is why I thought of using the IF() statement. If it's not possible, it's fine, I just want to be able to avoid that future change if I can.

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
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:

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Nice trick! I didn't know you could do that. Thanks for the help!