Forum Discussion

Bruno_OMB's avatar
Bruno_OMB
Regular Visitor
3 years ago

Problems getting cumulative totals

I'm having trouble getting the cumulative total. I can see the monthly total, but it does not accumulate as I would like. I couldn't find the logic of the thing. I have the following:   Valor por ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Bruno_OMB , for cumulative better to use a measure like

 

Cumm Sales = CALCULATE([Your Measure],filter(all('Date'),'Date'[date] <=max('Date'[date])))

Cumm Sales = CALCULATE([Your Measure],filter(allselected(date),date[date] <=max(date[Date])))

 

Or use window function

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc

 

Running Total/ Cumulative: https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=41

  • Bruno_OMB's avatar
    Bruno_OMB
    Regular Visitor
    3 years ago

    Thanks for the help!
    But I can't get the result I need. Even using the suggested methods, the result is the same.
    I would like to add up the monthly totals in the grand total row of the matrix. (10,800 + 11,300 + 11450....)