Solver Add-in functionality using power pivot (DAX)

[shashank]

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 ?

[Gozde]

I am interested in solution, do you have any process?

Thank you!

[v-ljerr-msft]

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. 

Goal seeking and XIRR in PowerBI and PowerQuery

Regards