Sum rows <= current row index

[KEB]

Thank you for your help! I added an index to a dataset that I need to sum a column based on the previous rows in the index. Simply sums Days in rows where the Index is less than or equal to the current row index. 
Example: Index Row 6, a new column would show 15.66.

               Index Row 4 a new column would show 6.11.

Thank you for your time.

[AlB · Accepted solution]

Hi @KEB 

Create a calculated column in your table:

New col =
CALCULATE (
    SUM ( Table1[Days] ),
    ALL ( Table1 ),
    Table1[Index] <= EARLIER ( Table1[Index] )
)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[KEB]

@AlB Thank you so much. This works perfectly!

[ChrisMendoza]

@KEB -

Like this? Or do you require something different?

[KEB]

@ChrisMendoza I see that this solution worked for you, however for me it produced the the same value as Days and didn't sum. We found a calculated column that works so no further action is needed. I just wanted to followup with you and thank you for your time to help me.