Detect number in a text string

Hi Anonymous ，

Text.contails could not work on more then one values, similar error refer:

https://community.powerbi.com/t5/Power-Query/using-if-text-Contains-for-multiple-conditions-in-Power-Query-M/td-p/2196090 

And change yours to the below:

if Text.Contains([Product], "1")  or Text.Contains([Product], "2")                   or Text.Contains([Product], "3")                   or Text.Contains([Product], "4")                   or Text.Contains([Product], "5")                   or Text.Contains([Product], "6")                   or Text.Contains([Product], "7")                   or Text.Contains([Product], "8")                   or Text.Contains([Product], "9")                   or Text.Contains([Product], "0")    then "True" else "False"

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien