Running Cumulative based on hours

Hi Anonymous,

I add a condition to summarize yesterday total on 12am, you can use following measure if it works for your requirement:

RunningTotal 2 = 
VAR currDate =
    MAX ( Daily_Methane_1[TimeStamp] )
RETURN
    IF (
        TIMEVALUE ( currDate ) <> TIME(0,0,0),
        CALCULATE (
            SUM ( Daily_Methane_1[FlowAtGivenInterval] ),
            FILTER (
                ALLSELECTED ( Daily_Methane_1 ),
                AND (
                    Daily_Methane_1[TimeStamp] >= DATEVALUE ( currDate ),
                    Daily_Methane_1[TimeStamp] < currDate
                )
            )
        ),
        CALCULATE (
            SUM ( Daily_Methane_1[FlowAtGivenInterval] ) + 0,
            FILTER (
                ALLSELECTED ( Daily_Methane_1 ),
                DATEVALUE ( Daily_Methane_1[TimeStamp] )
                    = DATEVALUE ( currDate ) - 1
            )
        )
    )

Regards,

Xiaoxin Sheng