Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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/
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.