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're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.