Running Sum Question

I am trying to create a running sum formula for a graph. The X-Axis should have the Date The Y-Axis should have the Running Sum Amount The Legend should be the transaction type, and thos...

Need Help

v-zhangti

3 years ago

Hi, vsslasd1

You can try the following methods.
Column:

Column = 
CALCULATE (
    SUM ( 'Table'[Amount] ),
    FILTER (
        'Table',
        [OverrideDate] <= EARLIER ( 'Table'[OverrideDate] )
            && [Transaction_Type] = EARLIER ( 'Table'[Transaction_Type] )
    )
)

Measure:

Running sum = 
CALCULATE (
    SUM ( 'Table'[Amount] ),
    FILTER (
        ALL ( 'Table' ),
        [OverrideDate] <= SELECTEDVALUE ( 'Table'[OverrideDate] )
            && [Transaction_Type] = SELECTEDVALUE ( 'Table'[Transaction_Type] )
    )
)