Forum Discussion

vaso's avatar
vaso
Frequent Visitor
2 years ago
Solved

Running Total

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])))
Running Totals
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    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] )
    )
)

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

    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] )
    )
)