cancel
Showing results for
Did you mean:
Helper I

calculate function (IF AND THEN)

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

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

1 ACCEPTED SOLUTION
Super User IV

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

---------------------------------------

I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

2 REPLIES 2
Super User IV

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

---------------------------------------

I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Helper I

many thanks.

Announcements

Happy New Year from Power BI

This is a must watch for a message from Power BI!