Forum Discussion

Sunny3366's avatar
Sunny3366
Regular Visitor
9 years ago

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