Running Total help to 0 months with no data

[PBrainNWH]

Seeking help to 0 out all under each highlighted value, as there is no data for these months. I'm assuming I can incorporate an ISBLANK() function, but having trouble with the syntax. Here's my table:

Here is the syntax for the three RTAct coulmns:

RTAct FAN = CALCULATE(SUM('Combined VE PL Pared (2)'[Actual Amount]),filter(allselected('Calendar'[Date]),'Calendar'[Date] <=max('Calendar'[Date])),'Combined VE PL Pared (2)'[Department Code]="30-FAN")

Thanks!!

[v-rongtiep-msft · Accepted solution]

Hi @PBrainNWH ,

Please have a try.

RTAct FAN =
VAR CurrentDate =
    MAX ( 'Calendar'[Date] )
VAR CurrentMonth =
    MONTH ( CurrentDate )
VAR CurrentYear =
    YEAR ( CurrentDate )
VAR HasData =
    NOT ISBLANK ( SUM ( 'Combined VE PL Pared (2)'[Actual Amount] ) )
RETURN
    1
        = IF (
            HasData,
            CALCULATE (
                SUM ( 'Combined VE PL Pared (2)'[Actual Amount] ),
                FILTER (
                    ALLSELECTED ( 'Calendar'[Date] ),
                    'Calendar'[Date] <= CurrentDate
                        && 'Combined VE PL Pared (2)'[Department Code] = "30-FAN"
                )
            ),
            IF (
                CurrentMonth > 1,
                CALCULATE ( [RTAct FAN], DATE ( CurrentYear, CurrentMonth - 1, 1 ) ),
                BLANK ()
            )
        )

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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