Create Running Total Column based on employee and continous dates

[mvgust]

I think the best solution to my problem is to create a running total column for a table.  I need to sum hours by employee for continous dates.  I'll then be using the numbers in that column do do further filtering.

Below is an example of my data:

Each time there is a gap in the date sequence for an employee, I need the running total to start over on summing the hours.

[CNENFRNL]

@mvgust , apparently, [Timecard ID] column already bins the table by consecutive days, thus you can authored a formula for calculated column like this,

Running Total =
SUMX (
    CALCULATETABLE (
        Data,
        ALLEXCEPT ( Data, Data[Timecard ID], Data[Employee ID] ),
        Data[date] <= EARLIER ( Data[date] )
    ),
    Data[Hours]
)

[mvgust]

While my table has timecard ID I can't use this as part of my context as we're looking at consecutive days regardless of what timecard the days fall into.