Forum Discussion
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 text in the cells and [item1] has only either 1 or 0.
The query keeps on returning 0 even if all conditions are met. I feel "<> null" is where the issue is but im not sure,kinda new to this.
=If [item1] = 1 and Text.Combine({[item2],[item3],[item4]})<>"" then 1 else 0
4 Replies
=If [item1] = 1 and not List.Contains({null,""},Text.Trim([item2])) 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
