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])))
     
Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

Hi dw700d 

Try this measure

RuningTotal = 
 VAR selectedDate = SelectedValue(Table[Date])
 VAR FilteredTable = Filter(
                       All(Table)
                       , Table[Date] <=selectedDate
                      ) 
Return Sumx(filteredTable, Table[Spend])

Hope this helps.

Thanks