Forum Discussion

Ramiroz's avatar
Ramiroz
Frequent Visitor
6 years ago

Transform table with maximum quantity of 100 per week

I doubt that this one has a solution in Power Query, however I thought to share it on this forum, maybe!   I have a dataset of weekly orders, which I need to limit to a weekly total quantity of 100...
Need Help
Jimmy801's avatar
Jimmy801
Icon for Community Champion rankCommunity Champion
6 years ago

Hello Ramiroz 

 

you need results per day, or just a leveld total number of orders per week?

 

BR

 

Jimmy

Ramiroz's avatar
Ramiroz
Frequent Visitor
6 years ago

Hi Jimmy801,

Yes I need it per day, no aggregation. As I have an order ID for each line, and need to keep the same structure, just reduce or increase or add a new entry to adjust to be below the 100 per week limit.

 

  • Jimmy801's avatar
    Jimmy801
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hello Ramiroz 

     

    this is for sure really challenging. Need List.Generate to go through the table, check week and orders, hold old week and current total orders of week, create new lines when some conditions is true. For sure feasable but I can't invest too much time fore a solution 🙂

    Maybe ImkeF is faster in that 🙂

     

    Sorry

     

    Jimmy