Forum Discussion
Calculate running total based on Sort Column
Hi Anonymous
Use and modify the below Formula as per your need.
Running Total COLUMN = CALCULATE ( SUM ( 'table'[col1] ), ALL( 'table'), //ALLEXCEPT ( 'table', 'table'[] ) //If you want to group by any column 'table'[col2] <= EARLIER ( 'table'[col2] ) )https://www.wallstreetmojo.com/power-bi-running-total/
Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit
Hi Anonymous
Use and modify the below Formula as per your need.
Running Total COLUMN =
CALCULATE (
SUM ( 'table'[col1] ),
ALL( 'table'), //ALLEXCEPT ( 'table', 'table'[] ) //If you want to group by any column
'table'[col2] <= EARLIER ( 'table'[col2] )
)https://www.wallstreetmojo.com/power-bi-running-total/
Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit
Thank you so much. This worked exactly as stated and I used the ALLEXCEPT filter to apply the running total to the applicable name.
Can you post the formula you used? I'm not getting the running total, just the total on each row when using the ALLEXCEPT filter. Table looks like below now -
User Amt Running Total 1 100 250 1 100 250 1 50 250 - Ashish_Mathur
Super User
Hi,
Do you have a Date column? If yes, then share that dataset.
