Forum Discussion
Need support on Converting Excel Solver to PowerBI
Hi all,
I wanted to know, how to convert the Excel solver into powerBI.
I am having Demand optimization using Excel Solver. i wanted to convert the Excel solver into powerBI (I already have output in Excel solver and i wanted to convert this to powerBI)
Any replies appriciated .
Thanks,
IMR
1 Reply
Excel Solver contains many different algorithms and there is no equivalent in Power BI (yet?).
You have to search for the specific algorithm you want to use, maybe someone has published a solution already.
I've published a goal-seek-algorithm for Power BI here for example: https://www.thebiccountant.com/2017/05/23/goal-seeking-and-xirr-in-powerbi-and-powerquery/#more-2081 or here: https://www.thebiccountant.com/2017/07/11/non-linear-break-even-analysis-in-powerbi/
