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:   Term Result  Deployed AA =IF(ISNUMBER(F...
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

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Anonymous ,

 

Try tihs in a new custom column:

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

 

Pete