Running Total that resets with new client name

[Anonymous]

Hi guys, I have just recently started learning Power BI and got stuck on one issue. I want to make new column in PBI which is named "Total distance" and it should be a running total where it does a reset when ever a new client name appers. Below I have attached a simplified table of how it should look.

Thank you in advance for any help given

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Running total: =
IF (
    NOT ISBLANK ( SUM ( Data[Distance] ) ),
    CALCULATE (
        SUM ( Data[Distance] ),
        'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
    )
)

[Anonymous]

You are absolute life saver! Thank you so much!