Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Request: Convert Excel Formula to M Language

Dears,

 

Good day 

 

I need your help to translate excel fornula "Result" that i writed below to M langauge to use the function in Power query:

 

TermResult 
Deployed AA=IF(ISNUMBER(FIND("Deployed",A2,1)),"Go Live","On Going")
Ongoing =IF(ISNUMBER(FIND("Deployed",A3,1)),"Go Live","On Going")
BB Deployed =IF(ISNUMBER(FIND("Deployed",A4,1)),"Go Live","On Going")

 

Best Regards, 

Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Anonymous ,

     

    Try tihs in a new custom column:

    if Text.Contains([Term], "Deployed") then "Go Live" else "Ongoing"

     

    Pete

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    4 years ago

    Hi Anonymous ,

     

    Try tihs in a new custom column:

    if Text.Contains([Term], "Deployed") then "Go Live" else "Ongoing"

     

    Pete