Forum Discussion

Helper II

4 years ago

IF esle Statement

IF else Statement Question Score A Yes B No C No D Yes A1 No B1 Yes C1 No D1 Yes Output Question Score A No B Yes C Yes D No A...

Super User

4 years ago

arvindarvind24 , a new column in the power query

if Text.Contains([Question], "1") then [#"Score"],

else if [Question] then Text.Replace([#"Score"],"No","Yes")

else Text.Replace([#"Score"],"Yes","No")