Forum Discussion
a_shamsuzzoha
5 years agoRegular Visitor
Rolling sum based on a measure
I have the following visual. A and B are table columns and C is a calculated measure. Can you created a rolling sum of B based on ascending order of C? Thanks in advance.
amitchandak
Super User
5 years agoa_shamsuzzoha , ascending order C or A ?
C can be a measure like
C =calculate(Sum(Table[B]), filter(allselected(Table), Table[A] <=max(Table[A])))
a_shamsuzzoha
5 years agoRegular Visitor
amitchandak Ascending order C