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
=If [item1] = 1 and Text.Combine({[item2],[item3],[item4]})<>"" then 1 else 0
That's it! thank you so much daniel.