Running sum by date , person

[PeterChu]

Hi Everyone,

I am trying to do a running sum by group in PowerBi DeskTop. Thank you.

Here is what my data looks like, I would like a running sum of the times in a new column.

Thank you all.

[sunshine1]

thanks this formula worked. I saw a bunch of other threads for running total but this was the only one that got the desired result.....

[Phil_Seamark · Accepted solution]

Hi @PeterChu

If you want to do it as a calculated column then please try this :

Running Total = 
    CALCULATE(
        SUM(Table1[Times]),
        FILTER(
            'Table1',
            'Table1'[MemberId]=EARLIER('Table1'[MemberId])
            && 'Table1'[Date] <= EARLIER('Table1'[Date])
            )
            )

[PeterChu]

It's work. Thank you very much.