Forum Discussion
Warehouse inbound accumulative count
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 |
2 Replies
- amitchandak
Super User
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])
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.
