Converting IF statement to Power BI

[MSDVA]

[FONT=&quot]I'm trying to covert the following Excel IF statement to a custom column in Power BI: =IF(O2<>P2,IF(O2>0,O2,P2),IF(P2=0, N/A,P2)) (replacing the cells with the column names) I cannot for the life of me figure out the syntax.

Any assistance is GREATLY appreciated.[/FONT]

 

[andydtaylor]

You need one of those reading book things!

= if [field 1] <> [field 2] and [field 1] > 0

then [field 1]

else

if [field 1] <> [field 2] and [field 1] <=0

then [field 2]

else

if [field 1] = [field 2] and [field 2] = 0

then

“N/A”

else

if [field 1] = [field 2] and [field 2] <> 0

then

[field 2]

 

[theBardd]

same as Excel really.

if [Field 1] <> [Field2] then if [Field 1] > 0 then [Field 1] else [Field2] else if [Field2] = 0 then "N/A" else [Field2]