Forum Discussion
Varan_15
2 years agoHelper III
Calculate Cumulative Sum
Hi All,
i have connected calander table and dim customer balance table now i would like to create monthly account level cumulative sum based on balance measure.
| Year | Month | CUSTTOMER ID | ACCOUNT_NO | Measure[Balance] | Cumulative sum |
| 2024 | March | 202011 | 111111 | 6000 | |
| 2024 | April | 202011 | 111111 | 3000 | 9000 |
| 2024 | May | 202011 | 111111 | 2000 | 11000 |
| 2024 | June | 202011 | 111111 | 1000 | 12000 |
| 2024 | July | 202011 | 111111 | 500 | 12500 |
need to create month on month sum of balance (cumulative sum) expected result kindly help on this
Thanks in advance
1 Reply
- ArulSuper User