Forum Discussion

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...

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] )
)

Community Champion

10 years ago

FawadRehman Why don't you want to do the Running Total in the new Merged Table?

Helper I

10 years ago

Sean any update sir?

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] ) )
- FawadRehman
  Helper I
  10 years ago
  Working like a charm. Thank You. btw do you know line break in text box?
  - Sean
    Community Champion
    10 years ago
    I know some people use the Long Text Viewer Custom Visual instead...
    https://app.powerbi.com/visuals/show/LongTextViewer1453740445633
- dstramilov
  Helper II
  10 years ago
  Who can solve these problems?
  http://community.powerbi.com/t5/Desktop/General-Ledger-to-Balance-Sheet-Financial-Statement/m-p/43036#M16516
- 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.

Related content