Cumulative total all ignore specific filter help

Hi everyone,

Long time stalker, first time poster - so thank you for all your help previously.

I've been struggling with time series data for a while now. Usually googling and youtubing eventually helped but i'm really stuck on this one even though it seems simple enough. I might not be getting my concepts right, so appreciate if any gurus can enlighten me as well. I have attached the data in excel here.

I have a list of processed goods in tonnes by hour, day and operator that I want to display the cumulative processed goods by hour.

I have managed to get the cumulative total to work when the hours are selected in a slicer with this code:

CALCULATE(
        SUM('table'[Processed (t)])
            ,FILTER(
                    ALLSELECTED('table'[End At Hour (Local)])
                        ,'table'[End At Hour (Local)] <= MAX('table'[End At Hour (Local)]))
            )

However, how can i get it to work when i want the first value to display the cumulative data from the hour prior. I googled and tested various methods but couldn't get it to work somehow. I konw i'm close and i'm missing something important.

I landed on 2 different methods that produced results:

1) using the 'ALL' function

2) using the 'ALLEXCEPT' function

However, Method 1 returned the daily total for the selected operator in each row, whilst Method 2 returned the daily total in each row.

Method 1 code:

CALCULATE(
        SUM('table'[Payload (t)])
            ,FILTER(
                    ALL('table'[End At Hour (Local)])
                        ,'table'[End At Hour (Local)] <= MAX('table'[End_At_Local]))
            )

Method 2 code:

CALCULATE(
        SUM('table'[Payload (t)])
            ,ALLEXCEPT('table','table'[End At Hour (Local)])
            ,'table'[End At Hour (Local)] <= MAX('table'[End_At_Local])
            )

Ideally i'd like it the graph to look like - 

Thank you very much.

Best,

Roy