Forum Discussion

dw700d's avatar
dw700d
Post Patron
6 years ago
Solved

Running Total by Date

I am trying to create a running total for the sum column by date for the below table. How can I accomplish this by creating a measure?   Date         Type       Spend 7/27/2020          EP...
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    dw700d ,

    Try this:

    CALCULATE(SUM(Sheet4[Value]),FILTER(ALL(Sheet4),Sheet4[Date]<=MAX(Sheet4[Date])))
     
dw700d's avatar
dw700d
Post Patron
6 years ago

Thank you all for your prompt responses