Forum Discussion
Solved
Power Pivot Formula Bogging down Excel
This is a power pivot question, not Power BI I am trying to determine if I have a favorable or unfavorable variance with a dynamic formula and it is locking up excel. I am not sure if it is my for...
BaldAccountant , I think it's a problem
(!_IsGood && _Diff <= 0)
Try, if not can work(Power BI we use not )
(not _IsGood && _Diff <= 0)
BaldAccountant , Try if this can help
Test Result :=
VAR _IsGood = [Selected good bad] = "Good"
VAR _Diff = [Test O]
RETURN
IF(
(_IsGood && _Diff >= 0) ||
(!_IsGood && _Diff <= 0),
"Good",
"Bad"
)
I am getting this error
I am not sure why it is showing the extra two ")" I just copied and pasted in your solution
BaldAccountant , I think it's a problem
(!_IsGood && _Diff <= 0)
Try, if not can work(Power BI we use not )
(not _IsGood && _Diff <= 0)That worked. Thanks