Forum Discussion
Sunny3366
9 years agoRegular Visitor
Rolling sum for consecutive rows in dax
Hello,
I am looking for a dax code to find rolling sum of consecutives rows of a column.
So if I have a column as given below:
| Freight |
| Rs. 89.46 |
| Rs. 85.00 |
| Rs. 85.00 |
| Rs. 17.48 |
| Rs. 85.00 |
| Rs. 89.46 |
| Rs. 89.46 |
| Rs. 84.37 |
I need the rolling sum column as below:
| 89.46 |
| 174.46 |
| 259.46 |
| 276.94 |
| 361.94 |
| 451.4 |
| 540.86 |
625.23
|
I have been able to achieve it in Excel but not in Dax.
Thanks in advance.
Sunny
1 Reply
- AnonymousNot applicable
I think this thread belongs in the Desktop section of the forum, but I learnt how to do this using this previous solution:
https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115