Forum Discussion

a_shamsuzzoha's avatar
a_shamsuzzoha
Regular Visitor
5 years ago

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.
Need Help
v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi a_shamsuzzoha ,

 

First, change column [C] to calculated column.

Measure = 
CALCULATE(
    SUM([B]),
    FILTER(
       ALLSELECTED(Table),
       [C] <= MAX([C])
    )
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.