Hey, Bill. Thanks for the XLSX files. Full solution attached. Here’s the key grouping step and the non-uniform daily allocation M code:
And this generates exactly the allocations expected monthly and daily, uniform and nonuniform:
I hope this is helpful, and that you find this approach as useful and versatile as I do. Full solution file attached.
- Brian
eDNA Forum - PQ Bud Alloc Multi Brands Solution.pbix (477.3 KB)