Solved: Re: Request: Convert Excel Formula to M Language

Anonymous · ‎03-09-2022

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(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,

BA_Pete · ‎03-09-2022

Hi @Anonymous ,

Try tihs in a new custom column:

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

Pete

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

BA_Pete · ‎03-09-2022

Hi @Anonymous ,

Try tihs in a new custom column:

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

Pete

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Request: Convert Excel Formula to M Language