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