Forum Discussion

FawadRehman's avatar
FawadRehman
Helper I
10 years ago
Solved

Running Total - DAX

I need help. I am looking for same solution http://community.powerbi.com/t5/Desktop/DAX-Running-total-by-another-column/m-p/10512#M2189 but somehow its not working for me.    RunningTotal...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    FawadRehman This should work... Let me know.

     

    Running Total COLUMN =
CALCULATE (
    SUM ( TabelForecast[Forecast] ),
    ALLEXCEPT ( TabelForecast, TabelForecast[M#] ),
    TabelForecast[MonthYear] <= EARLIER ( TabelForecast[MonthYear] )
)
Sean's avatar
Sean
Community Champion
10 years ago

FawadRehman This should work... Let me know.

 

Running Total COLUMN =
CALCULATE (
    SUM ( TabelForecast[Forecast] ),
    ALLEXCEPT ( TabelForecast, TabelForecast[M#] ),
    TabelForecast[MonthYear] <= EARLIER ( TabelForecast[MonthYear] )
)
Lucy64's avatar
Lucy64
Advocate II
10 years ago

Can I calculate a running total without a date field.  I have a list of Machine Names and production total for each machine.  With the production total showing in descending order I want to add a running total from highest to lowest.  Data is from SQL database with a direct link.  Please let me know if this is possible.  The idea is when I drill down or filter the calculation of the running total will recalculate based on data showing.