Running Cumulative based on hours

Anonymous

Creata a new table and add as dimension the timestamp sorted in Ascending order.

Then create a measure using the following formula and add it to the table.

If you want to see the running total for a specific date, add a dare slicer and select the date you want

Cumulative = 
CALCULATE (
    SUM ( Table[FlowAtGivenInterval] ),
    FILTER( ALL (Table ),
    Table[TimeStamp] <= MAX( Table[TimeStamp] ))
)

Hi Anonymous,

You can try to use following measure formula, I write formula to use date part as condition to limit cumulative date range:

Measure =
VAR currDate =
    MAX ( Table[TimeStamp] )
RETURN
    CALCULATE (
        SUM ( Table[FlowAtGivenInterval] ),
        FILTER (
            ALLSELECTED ( Table ),
            OR (
                DATEVALUE ( Table[TimeStamp] ) = DATEVALUE ( currDate ),
                Table[TimeStamp]
                    = DATEVALUE ( currDate ) + 1
            )
                && AND ( Table[TimeStamp] > DATEVALUE ( currDate ), Table[TimeStamp] < currDate )
        )
    )

Regards,

Xiaoxin Sheng