Forum Discussion
Solved
Text.Contains Error "cannot convert the value [string] to type logic"
Hi, I'm trying to createa calculated column that will search [application names] and tag those can contain certain text. My attempt is below: operations tag = if(Text.Contains([Applicat...
Hi,
Does this M language formula do the job?
=if Text.Contains([Application Name], "CIP1")=TRUE or Text.Contains([Application Name], "ETL")=TRUE or Text.Contains([Application Name], "OPS")=TRUE then "Operations Component" else null
Ashish_Mathur
Super User
Super UserHi,
Does this M language formula do the job?
=if Text.Contains([Application Name], "CIP1")=TRUE or Text.Contains([Application Name], "ETL")=TRUE or Text.Contains([Application Name], "OPS")=TRUE then "Operations Component" else null