Forum Discussion

kliz's avatar
kliz
Frequent Visitor
2 years ago
Solved

Cumulative Sum

Hello, I am a beginner in powerbi and I want to compute the cumulative sum for each day, which includes the current day's sale amount and the cumulative sum of the previous day's sales.  For exampl...
Need Help
  • Tahreem24's avatar
    Tahreem24
    2 years ago

    kliz YOu can try this measure, I took your example and generated the expected result.

     

    Cumulative = CALCULATE(SUM(TabA[Value]),FILTER(ALL(TabA),TabA[Date]<=MAX('TabA'[Date])))
     

     

Tahreem24's avatar
Tahreem24
Super User
2 years ago

kliz YOu can try this measure, I took your example and generated the expected result.

 

Cumulative = CALCULATE(SUM(TabA[Value]),FILTER(ALL(TabA),TabA[Date]<=MAX('TabA'[Date])))
 

 

kliz's avatar
kliz
Frequent Visitor
2 years ago

what if for some days there is no values, how can i make it so that it reproduces the previous value to the current and so on till if finds the next currentday value?