Forum Discussion
Optimization Rules/help
Hey Anonymous
While I'm sure Power BI can do this it would be long and complicated. I would like to suggest maybe using Excel Solver instead. It is designed specifically for problems like this and would be incrdibly useful as a template for future calculations. If fact, I have a problem in grad school that was very similar to the one you listed.
Load Solver in Excel: https://support.office.com/en-us/article/load-the-solver-add-in-in-excel-612926fc-d53b-46b4-872c-e24772f078ca
Microsoft examples: https://support.office.com/en-us/article/define-and-solve-a-problem-by-using-solver-5d1a388f-079d-43ac-a7eb-f63e45925040
Ablebits tutorial: https://www.ablebits.com/office-addins-blog/2016/06/22/how-to-use-solver-in-excel-with-examples/
Excel-easy tutorial: https://www.excel-easy.com/data-analysis/solver.html
My dad and I both do a lot of work with various BI softwares and when it comes to optimization of individual instances Solver is still the better tool.
If this helps please kudo.
If this solves your problem please accept it as a solution.
I am definitely going to look into the links and see.
But just to be clear, the example is just an example. There is 100s of customers like the ones with different total number of orders with different sizes and lbs.
But the rule for truck/frames is the same.
I understand. Here is a thread where a super user posted something similar to what I said: https://community.powerbi.com/t5/Power-Query/Need-support-on-Converting-Excel-Solver-to-PowerBI/td-p/745811
In order to state working it up in Power BI I would need a sample of the data.
Hey, This is the first time I have posted something. I prepared an excel sheet with the sample data. How do I attach the excel sheet? I do not see any icon to attach a file. Please guide.
Thanks
You can share links to dropbox, google drive, or take screen shots and upload those.