Forum Discussion

FawadRehman's avatar
FawadRehman
Icon for Helper I rankHelper 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
Icon for Community Champion rankCommunity 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] )
)