Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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