Need to stop running total at today's date

[simonek]

Hello! 

I'm sure there's a simple solution to this but the forms haven't shown me anything that works with this. I need to stop this running total formula with today's date. "[date.1]" represents all possible dates thru 2025. See below: 

ACTUALS = 

CALCULATE(
    [ACTUAL CALC],
    FILTER(
        ALLSELECTED('CALENDAR TABLE'[Date.1]),
        ISONORAFTER('CALENDAR TABLE'[Date.1], MAX('CALENDAR TABLE'[Date.1]), DESC)
    )
)

[Greg_Deckler · Accepted solution]

@simonek Try something like this:

ACTUALS = 
  VAR __Value =
    CALCULATE(
      [ACTUAL CALC],
      FILTER(
        ALLSELECTED('CALENDAR TABLE'[Date.1]),
        ISONORAFTER('CALENDAR TABLE'[Date.1], MAX('CALENDAR TABLE'[Date.1]), DESC)
      )
    )
  VAR __MaxDate = MAX('CALENDAR TABLE'[Date.1])
  VAR __Result = IF(__MaxDate > TODAY(), BLANK(), __Value)
RETURN
  __Result

[simonek]

This is *chef's kiss* perfection, thank you so much!!!