How to calculate running sum between 2 measures?

[sekhar438]

Hi Team,

How to calculate below highlighted calculations,

Thanks,

Chandrasekhar

[jdbuchanan71 · Accepted solution]

Hello @sekhar438 

Give this a try. 

RunningSum = 
VAR CurrentDate = SELECTEDVALUE ( 'Table'[date] )
RETURN
SUM ( 'Table'[D.qty] ) -
    CALCULATE( SUM ( 'Table'[r.qty] ),
        ALL ( 'Table' ),
        'Table'[date] <= CurrentDate
    )