Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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