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] )
        )
    )