-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 48-
(Solution in any language also welcome for Power Query Challenges)
— Input table Quantity data is wrong in picture. I updated Excel file with correct data —
101-1, 101-2 etc. are orders received for a customer in a day for a particular item named 101.
Quantity is the quantity of item ordered.
This item 101’s Max Size 10 means that one container can contain a maximum of 10 items.
101-1 and 101-2 are for a total of 9 items, hence they can be put into one single container.
101-3 is for 8 items, hence one single container will be required for this.
101-4 and 101-5 are for a total of 6+4 = 10 items which can fit in one container.
This number of containers need to be populated in a column as a RUNNING TOTAL.
Also Running Total of Quantity “WITHIN A CONTAINER” needs to be populated.
Download Practice File - https://lnkd.in/d-xHVMc3
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #excel, #excelchallenge
Excel BI’s LinkedIn Post