Seeking assistance with OR or switches....

[steambucky]

I would like to create a calculcated column that equals 1 IF the feild I am checking contains <null> ( no data ) OR the text "as needed" 

I have made similar things with "switches" but cant seem to get to grips with this. I have been looking at CONTAINS but can't seem to get anything that works.

Something like : update_frequency = If(Sir[Frequency of updates]), “as needed”or ISBLANK,1) 0)

Any pointers or help would be most welcome.

[v-yulgu-msft · Accepted solution]

Hi @steambucky,

update_frequency =
IF (
    Sir[Frequency of updates] = BLANK ()
        || NOT ( ISERROR ( FIND ( "as needed", Sir[Frequency of updates] ) ) ),
    1,
    0
)

Best regards,

Yuliana Gu

[steambucky]

This still doesnt work BUT is this closer? Any advice welcome.

update_frequency =

IF (

     (Sir[Frequency of updates]),ISBLANK, 1,

          IF((Sir[Frequency of updates]),’as needed’,1

0)

)

[steambucky]

This isn't working yet but is this heading more the right direction? Any advice welcome 

update_frequency = If
(ISBLANK(Sir[3.2_Frequency of updates])
IF(Sir[3.2_Frequency of updates],"as needed",
1,0
))