Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problem with creating running total with multiple categories

Hi,  I have looked at many different community posts but I haven't found one that's solution works with my problem. I am trying to create a running total for a dataset that contains multiple people...
Need Help
  • camargos88's avatar
    camargos88
    5 years ago

    Anonymous ,

     

    Try this measure:

     

    _Running Total = CALCULATE(SUM('Table'[Amount]), FILTER(ALL('Table'[Month]), 'Table'[Month] <= MAX('Table'[Month])))

     

camargos88's avatar
camargos88
Community Champion
5 years ago

Anonymous ,

 

Try this measure:

 

_Running Total = CALCULATE(SUM('Table'[Amount]), FILTER(ALL('Table'[Month]), 'Table'[Month] <= MAX('Table'[Month])))

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you!!!!!