Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Nested IF ELSE is not working - HELP PLEASE

I want to extract a different set of text from a column called "Description" when I used the Nested IF else statement in the custom column on power query it is not working or I could say the "OR" con...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use below

    if Text.Contains([Description],"Sptool identified") then Text.BetweenDelimiters([Description], "1.Exception: ", "2.Proce") as text
else
if Text.Contains([Description],"the exception being:") then Text.BetweenDelimiters([Description], "being:", "The impacted") as text
else
if List.ContainsAny({[Description]},{"invoice","eRTY","EnGMT","buET","ECT"},(x as text, y as text)=>Text.Contains(x,y)) then "CPM" as text
else "Check"
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Use below

if Text.Contains([Description],"Sptool identified") then Text.BetweenDelimiters([Description], "1.Exception: ", "2.Proce") as text
else
if Text.Contains([Description],"the exception being:") then Text.BetweenDelimiters([Description], "being:", "The impacted") as text
else
if List.ContainsAny({[Description]},{"invoice","eRTY","EnGMT","buET","ECT"},(x as text, y as text)=>Text.Contains(x,y)) then "CPM" as text
else "Check"