Forum Discussion
arvindarvind24
Helper II
Helper IIIF 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...
v-chenwuz-msft
Community Support
Community SupportHi 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