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
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi vaso ,

    I have created a simple sample, please refer to it to see if it helps you.

    Modify the measure.

    Running Total =
CALCULATE (
    SUM ( Kartela[bic] ),
    FILTER (
        ALL ( 'kartela' ),
        'kartela'[Posting Date] <= MAX ( 'kartela'[Posting Date] )
    )
)

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi vaso ,

I have created a simple sample, please refer to it to see if it helps you.

Modify the measure.

Running Total =
CALCULATE (
    SUM ( Kartela[bic] ),
    FILTER (
        ALL ( 'kartela' ),
        'kartela'[Posting Date] <= MAX ( 'kartela'[Posting Date] )
    )
)

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

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