Forum Discussion
Solved
Help with if and statement
Apologies if this was answered before. I am having issues with my if and statements in power query. =If [item1] = 1 and [item2] <> null then 1 else 0 Where [item2] just needs to have any te...
=If [item1] = 1 and Text.Combine({[item2],[item3],[item4]})<>"" then 1 else 0
Hi, thank you very much for this but its still returning 0 as a result. I think I screwed up explaining what I was trying to do. Basically I'm trying to put the fx below to my query.
=IF(AND(D3=1,LEN(E3)>0,LEN(F3)>0,LEN(G3)>0),1,0)
=If [item1] = 1 and Text.Combine({[item2],[item3],[item4]})<>"" then 1 else 0
That's it! thank you so much daniel.