HELP needed, Cumulative Total MEASURE (filling the blanks)

[gselvag]

I need help how to create measure that ignore (evaluation context dates) dates in between context dates.
The goal is to create a visual where date is context 2 year / month. We need to show month value and cumulative value.

DataTable:

Measure:

GM Total = 
VAR LastRD = MAX( DATA[ReportDate] ) //Last Report Date
VAR LastSD = MAX( 'Calendar'[Date] ) //Last Context Date
RETURN
IF ( LastSD > LastRD; 
    CALCULATE( SUM(DATA[Value]); FILTER( ALL('Calendar'); 'Calendar'[Date] <= LastRD) ); BLANK() )

Please help with the measure on how to fill the blanks (Ref. RED values). We tried the TOTALYTD works but does not sum cumulative over years. Appreciate your help.

[v-piga-msft · Accepted solution]

Hi @gselvag,

Please change your formula like below.

GM Total =
VAR LastRD =
    MAX ( DATA[ReportDate] ) //Last Report Date
VAR LastSD =
    MAX ( 'Calendar'[Date] ) //Last Context Date
RETURN
    IF (
        LastSD > LastRD,
        CALCULATE (
            SUM ( DATA[Value] ),
            FILTER ( ALL ( 'Calendar' ), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) )
        )
    )

Then you could get your desired output. 

In addition, you also could use TOTALYTD like with formula below.

YTD = TOTALYTD(SUM(Data[Value]),DATESYTD('Calendar'[Date]))

Best Regards,

Cherry