Forum Discussion
shashank
Helper III
Helper IIISolver Add-in functionality using power pivot (DAX)
Hi everyone ,
just wanted to check there is one model in excel which is using solver add-in functionality of excel for some calculations , can we achive the same using DAX if clients wants to migrate there model on power BI ?
One example would be implimenting Goal Seek functionality using DAX ?
2 Replies
v-ljerr-msftMicrosoft Employee
Hi shashank,
Honestly, I am not very familiar with solver add-in functionality of excel. However, based on my research, the Goal Seek functionality could be implemented with DAX in Power BI. Following is the article for your reference. :smileyhappy:
Goal seeking and XIRR in PowerBI and PowerQuery
Regards
GozdeHelper I
I am interested in solution, do you have any process?
Thank you!