IF

[kitkat23]

Hi,

I have the below if that is flagging any cells that have a number < 60 in a column, but there are also blanks in that column that i want exxcluding, how do I do it:

Flag_1HrWait = IF(ED[Time to  seen (minutes)] < 60, 1, 0)

Any help appreciated

[kitkat23]

thank you very much.  What i am finding is the measure is not showing the field 'ED[Time to seen (minutes)'

in the selection and i dont know why because it is a number field?  what am I not seeing??

[kitkat23]

sorry i accepted the solution and not sure if that closed this call

[Martin_D]

This code only works for a calculated column, not for a measure. Maybe you have chosen new measure instead of new column? If unsere, you could share your file.

[kitkat23]

The field '[Time to seen (minutes)' is a field built with a SQL table it is not anything I am calcuating in power bi.  It contains numbers and blanks

[kitkat23]

sorry ignore the above using the below it now has error:

Flag_1HrWait = IF(NOT(ISBLANK(ED[Time to seen (minutes)])), IF(ED[Time to seen (minutes)] < 60, 1, 0))

'The expression refers to multiple columns. Multiple columns can not be converted to scalar value'
what does that mean.  The field does appear in another table but I am saying what table to look at in the formula?

 

[Martin_D]

Can you provide the file including the code that produces the error, pls.?

[Martin_D · Accepted solution]

If blank input values shall result in blank output value:

Flag_1HrWait = IF(NOT(ISBLANK(ED[Time to seen (minutes)])), IF(ED[Time to seen (minutes)] < 60, 1, 0))

If blank input values shall result in 0 output value:

Flag_1HrWait = IF(AND(ED[Time to seen (minutes)] < 60, NOT(ISBLANK(ED[Time to seen (minutes)]))), 1, 0)