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"
)
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.