Forum Discussion

anwargabr's avatar
anwargabr
Helper I
4 years ago

Running Total Measures

Dear ,  I need your help to prepare cashflow on power bi, the issue is that I can show the cash balance by running total measure for the total day, but if i tried to look by transaction I can't.

 

apperciate if some one could help in this.

Need Help

6 Replies

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    Can you provide a little more information?

    Some examples of the data in the tables and a picture of your data model.

    Even better would be a demo pbix with some fake data in it.

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, anwargabr 

     

    Can you provide simple EXCEL data and PBIX files for testing? Sensitive data can be removed. Also need to please clarify the meaning of some of your fields. What kind of results do you expect? Hopefully, you can show it with an example graph.

     

    Looking forward to your reply.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • smpa01's avatar
    smpa01
    Community Champion
    4 years ago

    anwargabr  try this measure

    _runningBalance = 
CALCULATE (
    SUM ( Append1[Cr] ) - SUM ( Append1[Dr] ),
    FILTER ( ALLSELECTED ( 'Calendar' ), 'Calendar'[Date] <= MAX ( Append1[Date] ) )
)