Forum Discussion

KEB's avatar
KEB
Icon for Helper I rankHelper I
5 years ago
Solved

Sum rows <= current row index

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 curre...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    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 

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

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's avatar
KEB
Icon for Helper I rankHelper I
5 years ago

AlB Thank you so much. This works perfectly!