Forum Discussion

cleadholm's avatar
cleadholm
New Member
3 years ago
Solved

Integrate Excel Solver with Power BI

I am working on creating an optimization scenario for a Power BI Dashboard.   The scenario is intended to maximize gross margin return on investment (GMROI) based on a promotional order quantity. T...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi cleadholm 
    You have the option to create "what if " scenarios too by using parameters.
    Please take a look at the linked tutorial:

    https://www.youtube.com/watch?v=HUhfz7dzfpA

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

cleadholm's avatar
cleadholm
New Member
3 years ago

Thank you for the response Ritaf1983 

 

I watched the tutorial, and the "what-if" parameters are helpful. However, I don't see anything being optimized in the example that was reviewed. In the example, I would essentially be looking to optimize the "Usage Parameter" so that we find the maximum number of "breach days". The dashboard shows the breach status by day based on the Usage that you set, but you have to adjust the usage to see the corresponding number of breach days. I want to see the optimal (maximum) GMROI without having to test multiple values (Order Quantity).

 

I hope this helps!