Rolling Totals but hide Future Months

[TapZxK]

Hi All,

I have created a measure that allows me to compare Time Invest per month last FY & Current Fiscal. 

In the data set, I currently have all the data up until & including April 2023, when I put the measure on a clustered column chart visual or table visual the April numbers keep repeating until end of the Fiscal.

Is there a way to show future months as 0 until actual data comes in for those months?

My Fiscal Starts on 01-September

Rolling Total Hours =
VAR CurrentYearHours =
    CALCULATE ( [Total Time Invested], DATESYTD ( Calendar[Date], "08/31" ) )
RETURN
    TOTALYTD (
        CurrentYearHours,
        Calendar[Date],
        FILTER (
            ALL ( 'Calendar'[Date] ),
            'Calendar'[Date] >= DATE ( YEAR ( MAX ( 'Calendar'[Date] ) ), 9, 1 )
                && 'Calendar'[Date]
                    <= DATE ( YEAR ( MAX ( 'Calendar'[Date] ) ) + 1, 8, 31 )
        )
    )

Thank you for your help. 

[Greg_Deckler · Accepted solution]

@TapZxK Try:

Rolling Total Hours =
VAR MaxDate = MAX( 'Calendar'[Date])
VAR CurrentYearHours =
    CALCULATE ( [Total Time Invested], DATESYTD ( Calendar[Date], "08/31" ) )
VAR TYTD = 
    TOTALYTD (
        CurrentYearHours,
        Calendar[Date],
        FILTER (
            ALL ( 'Calendar'[Date] ),
            'Calendar'[Date] >= DATE ( YEAR ( MAX ( 'Calendar'[Date] ) ), 9, 1 )
                && 'Calendar'[Date]
                    <= DATE ( YEAR ( MAX ( 'Calendar'[Date] ) ) + 1, 8, 31 )
        )
    )
VAR Result = IF( MaxDate > TODAY(), BLANK(), TYTD )
RETURN
Result