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

     

     

     

v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
1 year ago

Hi e175429 , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.