Forum Discussion

e175429's avatar
e175429
Icon for Helper IV rankHelper IV
1 year ago
Solved

Running Totals

Hello All,   This is a sample of my data: Anyone know what I should do to get the running totals for the Users? Mind you, my actual data is over 43,000 rows.   I tried to upload a sample ...
  • techies's avatar
    techies
    1 year ago

    Hi e175429 please try this

     

    Running Total =
    CALCULATE (
        COUNTROWS(payments),
        FILTER (
            ALLEXCEPT ( payments, payments[User] ),  
            payments[PaidDate]<= MAX ( payments[PaidDate] )
        )
    )
     

     

     

     

techies's avatar
techies
Icon for Super User rankSuper User
1 year ago

Hi e175429 please try this

 

Running Total =
CALCULATE (
    COUNTROWS(payments),
    FILTER (
        ALLEXCEPT ( payments, payments[User] ),  
        payments[PaidDate]<= MAX ( payments[PaidDate] )
    )
)