Forum Discussion
Goal seek function
Hi
I've seen one of the cases that been solved https://community.powerbi.com/t5/Desktop/HELP-WITH-DAX-Simulate-Excel-What-If-Analysis-Goal-Seek/m-p/1008097
which is too similar to something I've been struggling with I will use the same letter he used, the difference is that I want my goal always to be zero:
( A * x ) - ( B * x ) = 0
How its gonna work?
I really appreciate your efforts, It will mean a lot if you know the solution!
1 Reply
- Not sure the Algebra works on that one.
(A * x) - (B * x) = 0
x * (A - B) = 0
x = 0 / (A - B)
x = 0
So, x = 0
