Warehouse inbound accumulative count

[Anonymous]

I am trying to work out how to show pallets coming into my warehouse vs the maximum capacity i can recieve by hour. 

Each hour of the day i can recieve 88 pallets, if in hour 1 i recieve 70, i have extra capacity for 18. In hour 2 i want to tip 104 i would have 16 left over. That 16 would then role into the 3rd hour and so on. 

How is the best way to calculate this. Below is the data i am working with. 

Time Bins	Pallets inbound	Maximum tip per hour	Variance
01:00:00	70	88	-18
02:00:00	104	88	16
03:00:00	156	88	68
04:00:00	26	88	-62
05:00:00	52	88	-36
06:00:00	130	88	42
07:00:00	52	88	-36
08:00:00	0	88	-88
09:00:00	156	88	68
10:00:00	52	88	-36
11:00:00	44	88	-44
12:00:00	26	88	-62
13:00:00	26	88	-62
14:00:00	52	88	-36
15:00:00	78	88	-10
16:00:00	148	88	60
17:00:00	0	88	-88
18:00:00	52	88	-36
19:00:00	26	88	-62
20:00:00	182	88	94
21:00:00	156	88	68
22:00:00	234	88	146
23:00:00	166	88	78

[amitchandak]

@Anonymous , Try a new column like

sumx(filter(Table, [Time Bins] <= earlier(Table[Time Bins])), [Pallets inbound]-[Maximum tip per hour])

or a measure

sumx(filter(allselected(Table), [Time Bins] <= max(Table[Time Bins])), [Pallets inbound]-[Maximum tip per hour])

[Anonymous]

Thank you for the suggestion, it doesnt quite give me the right numbers by adding a column or creating a measure. 

I have managed to replicate it in excel and have got the below results which is correct as if the inbound is less than the 88 maximum tip then the remaining from the previous hour would role over.