Forum Discussion
Power Pivot Formula Bogging down Excel
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
For some reason if I use a second variable for the "Bad" instead of ! _IsGood then it works.
Test Result:=VAR _IsGood = [Selected good bad] = "Good"
Var isbad = [Selected good bad]="Bad"
VAR _Diff = [Test O]
RETURN
IF(
(_IsGood && _Diff >= 0) ||
(isbad && _Diff <= 0),
"Good",
"Bad"
)
I am not sure what to do as far as marking a solution? I will wait and if you can tell me what I did wrong using your solution I will mark yours as the solution. I want you to get credit for tellin me to use variables.
