Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 ha...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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.