Need support on Converting Excel Solver to PowerBI

[Anonymous]

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

[ImkeF]

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/