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

     

     

     

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
1 year ago

Power BI (DAX):

 

Running Total =
CALCULATE(
COUNTROWS('Table'),
FILTER(
ALLSELECTED('Table'),
'Table'[User] = MAX('Table'[User]) &&
'Table'[PaidDate] <= MAX('Table'[PaidDate])
)
)


SQL:

 

COUNT(*) OVER (PARTITION BY [User] ORDER BY PaidDate) AS RunningTotal