IF esle Statement

[arvindarvind24]

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
A1	No
B1	Yes
C1	No
D1	Yes

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

@amitchandak @bvanderwatt @Rayshin @tamerj1 @SpartaBI 

[v-chenwuz-msft]

Hi @arvindarvind24 ,

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

Result:

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[arvindarvind24]

@v-chenwuz-msft Thank you 

For 1st Question No 01 it's working but how to apply for Question No 02

[amitchandak]

@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")