Graph not dipslaying measure correctly

Hi alycianw ,

Try the following expression

Dynamic Value = 
VAR CurrentDate = TODAY()
VAR Actuals = SUM('Data Center Data'[Actuals])
VAR Budget = SUM('Data Center Data'[Budget])
VAR LE = SUM('Data Center Data'[LE])
RETURN
    SWITCH(
        TRUE(),
        MAX('Data Center Data'[Date]) < CurrentDate, Actuals + Budget,
        MAX('Data Center Data'[Date]) >= CurrentDate, Actuals + LE,
        BLANK()  
    )

Please feel free to correct me and provide more information if I have misunderstood you!

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Resolved my issue by adding a new column identifying if it is a past or future month and based on that column it was able to filter out future months for budget and past months for LE. Thank you for the help