Forum Discussion
IF statment doesn't work!
Beyondforce Try the following. I assume you want the column to return 0 if both LateEnd and/or LateStart = 0
Column = IF(AND([LateStart]= 0, [LateEnd] = 0),0)
I'm also assuming that these are columns. Ideally it should read to include the table name, not using the table name implies a measure only:
Column = IF(AND('Table1'[LateStart]= 0, 'Table1'[LateEnd] = 0),0)
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."
Beyondforce Are you creating a Calculated column?
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 3I 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.