Running total until last date (running total doesn't stop..)

[colourfullife]

Hi,

Need help!

I have a cumulative graph has lines from different source.

To put all values with different range of dates, I made a master Calendar.

I want to show P running total in date till last date.

Any idea would be appreciated.

[v-yuezhe-msft · Accepted solution]

@colourfullife ,

Please add a IF condition in your DAX as shown in the example below, for more details, please check this blog: https://www.daxpatterns.com/cumulative-total/.

running total = 
IF (
    MIN ( 'Date'[Date] )
        <= CALCULATE ( MAX ( Table1[Date] ), ALL ( Table1) ),
    CALCULATE (
        SUM ( Table1[Amount] ),
        FILTER (
            ALL ( 'Date'[Date] ),
            'Date'[Date] <= MAX ( 'Date'[Date] )
        )
    )
)
 

Regards,
Lydia