Forum Discussion

ManuApo's avatar
ManuApo
Icon for Helper II rankHelper II
5 years ago
Solved

Struggling closing/writing IF statement :(

Hello community, I am struggling closing an IF statement, it's almost done but there is something else I need to do.  Basically when the if statement is calculated, I just want to in casa the...
Need Help
Tips and Tricks
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi ManuApo 

    Calculate the value first then check if it equals -1 and return the appropriate value

    Use this code - note that I haven't typed out the entire CALCULATE. Please supply code as text raher than an image so it doesn't have to be retyped.

     

    First answer by UW Timeline = 

VAR Res = CALCULATE( SUM('Calendar'[Workday]), .......

RETURN 

IF (Res = -1, 0, Res)

     

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi ManuApo 

Calculate the value first then check if it equals -1 and return the appropriate value

Use this code - note that I haven't typed out the entire CALCULATE. Please supply code as text raher than an image so it doesn't have to be retyped.

 

First answer by UW Timeline = 

VAR Res = CALCULATE( SUM('Calendar'[Workday]), .......

RETURN 

IF (Res = -1, 0, Res)

 

Regards

Phil

ManuApo's avatar
ManuApo
Icon for Helper II rankHelper II
5 years ago

Thank you so much PhilipTreacy !! 

I dont know how I couldn't think about that one! 

Thanks again 🙂
Manu.