Forum Discussion
laphroaig76
Helper I
Helper IAccount statement with running total
Hello community I have connected our accounting system and now I want to map a bank statement in PowerBI. I have the following columns: Date, posting text, amount, running total. Now my current fo...
some_bih
Community Champion
Community ChampionHi laphroaig76 if you simply need running total (rt), and your solution is slow, one alternative is to calulate rt in power query. Check link. Hope this help
https://gorilla.bi/power-query/running-total/
laphroaig76Helper I
Helper IIt does not help. I have not only shirts in my table. I have dozens of accounts and account transactions in this journal and for whatever reason, when I include the posting text, if the texts are the same, it adds this together and if there are new texts, it starts adding back at zero.