topic Re: Running Total in DAX Commands and Tips

Running Total

vaso — Sat, 13 Jan 2024 21:59:34 GMT

Hi I have a table named 'Kartela' with posting date and amount i need to build a measure according to other solutions in the comunity but it does not completely work . When I keep the table simple it works

but when i add more info like the remarks of the movement is not working

any idea how to fix it ?

thea measure is

Running Total = Calculate ( SUM(kartela[blc]), FILTER( ALL('kartela'[Posting Date] ),'kartela'[Posting Date] <= MAX('kartela'[Posting Date])))

Re: Running Total

Jihwan_Kim — Sun, 14 Jan 2024 04:07:13 GMT

HI, I am not sure how your desired outcome looks like, but try something like below whether it suits your requirement.

It is the running total by Remarks.

Running Total = CALCULATE ( SUM ( kartela[blc] ), FILTER ( ALL ( 'kartela' ), kartela[Remarks] = MAX ( kartela[Remarks] ) && 'kartela'[Posting Date] <= MAX ( 'kartela'[Posting Date] ) ) )

Re: Running Total

powerbi_zone — Wed, 21 Feb 2024 02:36:33 GMT

Running total can be easily achieved using the method shown in this video .Hope this helps .

https://youtu.be/NBGGHdKxupk

There is also a method for a non date value : https://youtu.be/85sKPSnc_GE