Forum Discussion
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.
v-lionel-msft
Community Support
Community SupportHi ashamsuzzoha ,
What is the DAX formula for your measure [C]?
I need a complete sample data model.
Or you can refer to my .pbix file.
My [C] is a sorting of [A], so I add up according to [A] to avoid using measure [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.