Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional Running Total (cumulative total)

Hi Everyone,
I have stuck at this point of time due to this issue. I have searched everywhere but did not find the solution which I required. Below is a table which I need to create in Power BI.

 

I know how to calculate Running Total but here the requirement is that for a particular row if Amount is 0 then Running Total should be 0.

Any help would be greatly appreciated.

Interesting Links
Need Help
Tips and Tricks

1 Reply

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    Try this Measure

    Measure = 
VAR _MaxDate = CALCULATE( MAX( 'Table'[Date] ), 'Table'[Amount] > 0 )
RETURN 
CALCULATE(
    SUM( 'Table'[Amount] ),
    ALL( 'Table' ),
    'Table'[Date] <= _MaxDate
) + 0
    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski