Forum Discussion
Mackie
Helper I
Helper IHow to Cumulative Sum?
How can I calculate column "C" from "A" & "B" columns? Thank you. a b c 0 7 7 3 10 17 6 2 19 9 4 23 12 9 32 15 18 50
Well, you cannot unless you have an Index column or the value of A for each row of increases in a sorted fashion. If the latter is indeed the case then you could do this:
c = SUMX(FILTER('Table',[a] <= EARLIER([a])),[b])
Greg_Deckler
Community Champion
Community ChampionWell, you cannot unless you have an Index column or the value of A for each row of increases in a sorted fashion. If the latter is indeed the case then you could do this:
c =
SUMX(FILTER('Table',[a] <= EARLIER([a])),[b])
MackieHelper I
Helper IThank you, Greg_Deckler . Your formulate works for me.
If you know any page which explains "EARLIER" function, please let me know.