Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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