calculate function (IF AND THEN)

[sabin_arsenal]

needHello, wondering if anyone could help calculate the following logic for me in dax (not a coder)

thanks much in advance

IF C_O>=0, then

calculate -(U_P)-(B_Y)+(L_W)

ELSE 

CALCULATE -(U_P)+(B_Y)+(L_W)

C_O	U_P	B_Y	L_W	expected value
-4.30	0.098	0.705	0.197	-0.607
-1.80	0.426	0.265	0.309	-0.382
-7.50	0.304	0.670	0.027	-0.946
-9.10	0.294	0.669	0.037	-0.926
10.00	0.038	0.641	0.321	0.923
7.10	0.135	0.740	0.125	0.729
1.50	0.433	0.167	0.400	0.133

[Greg_Deckler · Accepted solution]

Your psuedo-code is pretty close actually:

expected value column =
  IF(
    [C_O] >= 0,
    -1*[U_P] - [B_Y] + [L_W],
    -1*[U_P] + [B_Y] + [L_W]
  )

[sabin_arsenal]

many thanks.