Forum Discussion
Solved
Sum from first line to current line
I have one column named "Result", 1 means success, 0 means fail. How should I calculate the total success count from frist line to current line? The final result should be like following:
Result Total
1 1
0 1
1 2
1 3
0 3
Running Total COLUMN = CALCULATE ( SUM ( 'Sheet1'[Values] ), ALL ( 'Sheet1' ), 'Sheet1'[ID] <= EARLIER ( 'Sheet1'[ID] ) )Lets say ID is the name of your first column and values is the second column
KerwenZhang Please add an Index column in "Power Query Editor" and then use the below logic in Data pane as New Column
Total = CALCULATE(SUM(Test158CummSum[Result]),FILTER(Test158CummSum,Test158CummSum[Index]<=EARLIER(Test158CummSum[Index])))
2 Replies
- PattemManohar
Community Champion
KerwenZhang Please add an Index column in "Power Query Editor" and then use the below logic in Data pane as New Column
Total = CALCULATE(SUM(Test158CummSum[Result]),FILTER(Test158CummSum,Test158CummSum[Index]<=EARLIER(Test158CummSum[Index])))
- themistoklis
Running Total COLUMN = CALCULATE ( SUM ( 'Sheet1'[Values] ), ALL ( 'Sheet1' ), 'Sheet1'[ID] <= EARLIER ( 'Sheet1'[ID] ) )Lets say ID is the name of your first column and values is the second column