Forum Discussion

Helper I

9 years ago

Solved

IF statment doesn't work!

Hey Guys, I'm trying to add a new column and I'm also adding this formula, but it's not working! What's wrong with it? =IF([LateStart]= 0, && ([LateEnd] = 0),0)) Thanks. Ben.

Vvelarde
9 years ago
Beyondforce

Hi, not the best but works

Helper I

9 years ago

Hi Anonymous,

Thanks for your replay. I have tried both option, but I kepp getting the same error: "Expression.Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly."

Anonymous

Not applicable

9 years ago

Beyondforce Are you creating a Calculated column?

Beyondforce
Helper I
9 years ago
I have 2 columns with 1 and 0. In the new column I want to create 4 option:
LateStart LateEnd Status
0 0 0
1 0 1
0 1 2
1 1 3

I need to use the IF and AND statment to create the result in the "Status" column. Later I'll use a color condition for all the 4 number options in the Status column.
- Vvelarde
  Community Champion
  9 years ago
  Beyondforce
  
  Are you doing this in Query Editor? or in a Calculated Column?
  - Beyondforce
    Helper I
    9 years ago
    In here:
- Anonymous
  Not applicable
  9 years ago
  Beyondforce
  Status = IF(AND('Table1'[LateStart] = 0, 'Table1'[LateEnd]= 0), 0, IF(AND('Table1'[LateStart] = 1, 'Table1'[LateEnd]= 0), 1, IF(AND('Table1'[LateStart] = 0, 'Table1'[LateEnd]= 1), 2, IF(AND('Table1'[LateStart] = 1, 'Table1'[LateEnd]= 1), 3, 99) ) ))
  
  You can use the above if you are in the model using DAX. (Noted after seeing VV posted.)
  - Beyondforce
    Helper I
    9 years ago
    Anonymous, I have tried you script, but it still doesn't work!
    Vvelarde I have tried your script and it's working :)
    
    Thank you both for your time and help.
    
    Cheers.

Related content