Forum Discussion

learner03's avatar
learner03
Post Partisan
4 years ago
Solved

If condition with OR

How can I create a column that says 1 for when Length of Document is 8 or when it is Blank and otherwise 0. I tried with this but it it giving me error- if(or(LEN('On Purchase'[Join]=8),LEN('On Pu...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    learner03 

    i think the braket is not correct

    pls try this

    if(or(LEN('On Purchase'[Join] )=8,LEN('On Purchase'[Join] ) =0),1,0)

  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    learner03 

    pls try this

    if Text.Length([Join]) = 8 then 0 else if Text.Length([Join])=0 then 0 else 1

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

learner03 

i think the braket is not correct

pls try this

if(or(LEN('On Purchase'[Join] )=8,LEN('On Purchase'[Join] ) =0),1,0)

  • learner03's avatar
    learner03
    Post Partisan
    4 years ago

    ryan_mayu How can I write same function in Power Query?

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      4 years ago

      learner03 

      pls try this

      if Text.Length([Join]) = 8 then 0 else if Text.Length([Join])=0 then 0 else 1