How to reschedule EDD based on production capacity - Power Query

shafiz_p your current daily production capacity (e.g. OFFSET = 100,000) is not enough to place all orders across your current working calendar. I also did not get your message about "urgent" stuff - what's that? 

Can't also comment on your "table will grow day by day". This code just works with the list of orders in OrderDetails table. 

let
    // fx to find position of working day in the list
    wd_position = (d as date) => List.PositionOf(working_days, d, Occurrence.First),
    // list of working days
    working_days = List.Buffer(
        List.Sort(
            List.Difference(
                Table.SelectRows(CalendarTable, (x) => x[Is Working Day] = "True")[Date],
                Yearly_Holidays[Date]
            )
        )
    ),
    // capacity by product type
    caps = Function.Invoke(Record.FromList, List.Reverse(Table.ToColumns(Capacity))),
    // orders sorted by prod type and estimated DD
    sorted = Table.Sort(OrderDetails, {"Product Type", "EDD", "CS Approved Date"}),
    // and >> to list
    orders = List.Buffer(Table.ToList(sorted, (x) => x)),
    // go over the list
    processing = List.Generate(
        () => [
            i = 0,
            prod = orders{0}{3},
            iw = wd_position(orders{0}{7}),
            cap = Record.Field(caps, prod),
            flag = orders{0}{5} > cap,
            current_qty = if flag then 0 else orders{0}{5},
            cap_usage = current_qty
            //delivery_date = orders{0}{7}
        ],
        (x) => x[i] < List.Count(orders),
        (x) => [
            i = x[i] + 1,
            prod = orders{i}{3}, // current order's product type
            same_prod = x[prod] = prod, // check if prod type is the same as last order 
            cap = if same_prod then x[cap] else Record.Field(caps, prod), // current capacity
            flag = orders{i}{5} > cap, // check if qty is greater than cap
            current_qty = if flag then 0 else orders{i}{5}, // this order usage quantity
            cap_is_full = (not same_prod) or 
                (x[cap_usage] + current_qty) > cap or
                working_days{x[iw]}? is null or
                orders{i}{7} > working_days{x[iw]}, // reset capacity??
            cap_usage = if cap_is_full then current_qty else x[cap_usage] + current_qty, // capacity used
            iw = if (not same_prod) then wd_position(orders{i}{7}) // position in working days calendar
                else if cap_is_full  
                    then x[iw] + 1 
                    else x[iw]
        ],
        (x) => orders{x[i]} & (if working_days{x[iw]}? is null 
            then {null, null, null, "calendar is full"}
            else {x[cap], x[cap_usage], working_days{x[iw]}, if x[flag] then "order out of capacity" else null}
        )
    ),
    result = Table.FromList(processing, (x) => x, Table.ColumnNames(sorted) & {"capacity", "usage", "assigned_EDD", "flag"})
in
    result