Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have 3 columns called "ID" , "Description" and "Steps". Descrption contains texts. I would like to create a new column that counts the number of times "if" appears in each cell(row) of the column "description"
Solved! Go to Solution.
Here is one way to do it. You can add a custom column with this expression.
= List.Count(List.Select(Text.Split([Description], " "), each Text.Upper(_) = "IF"))
Pat
Here is one way to do it. You can add a custom column with this expression.
= List.Count(List.Select(Text.Split([Description], " "), each Text.Upper(_) = "IF"))
Pat