Forum Discussion

sabin_arsenal's avatar
sabin_arsenal
Helper I
6 years ago
Solved

calculate function (IF AND THEN)

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_OU_PB_Y L_Wexpected value
-4.300.0980.7050.197-0.607
-1.800.4260.2650.309-0.382
-7.500.3040.6700.027-0.946
-9.100.2940.6690.037-0.926
10.000.0380.6410.3210.923
7.100.1350.7400.1250.729
1.500.4330.1670.4000.133

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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]
  )

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    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]
  )