Forum Discussion
Excel Cumulative Sum
Ubaid ur Rahman , I tried to do that on your data model, but didn't catch what do you calculate in it. Thus emulate on the table
It is named as Range in data model, the measure will be
CumulativeCountDifd:=CALCULATE ( SUM ( [Actual value] )/COUNTROWS(Range), FILTER ( ALLEXCEPT ( Range, Range[Year] ), Range[Month] <= MAX ( Range[Month] ) ) )You may it in Power Pivot and result is in second sheet.
SergeiBaklan yes! as shown in the picture that how to simply apply that above formula to that column.
Ubaid ur Rahman and how do you pivot first column, what gives 2.27 in Grand total?
SergeiBaklan I don't need grand total. It comes up auto. So if possible without Grand total.
Ubaid ur Rahman , I tried to do that on your data model, but didn't catch what do you calculate in it. Thus emulate on the table
It is named as Range in data model, the measure will be
CumulativeCountDifd:=CALCULATE ( SUM ( [Actual value] )/COUNTROWS(Range), FILTER ( ALLEXCEPT ( Range, Range[Year] ), Range[Month] <= MAX ( Range[Month] ) ) )You may it in Power Pivot and result is in second sheet.