Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 example, let's say we have a table with columns for 'Date' and 'Amount':
Date Amount
2024-04-01 100
2024-04-02 150
2024-04-03 200
2024-04-04 120
The cumulative sum for each day would be:
For 2024-04-01: 100
For 2024-04-02: 100 (from 2024-04-01) + 150 = 250
For 2024-04-03: 250 (from 2024-04-02) + 200 = 450
For 2024-04-04: 450 (from 2024-04-03) + 120 = 570
How can i do that?
Solved! Go to Solution.
@kliz YOu can try this measure, I took your example and generated the expected result.
@kliz YOu can try this measure, I took your example and generated the expected result.
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?
Thank you. It worked.
@kliz Better Running Total - Microsoft Fabric Community
Thank you for your input. I watched your video and I'll keep that in mind. I tried to apply it to my data but i did not get the expected result is there something i should add?