Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
06-09-2019 03:11 AM
This is the DAX formula
DAX formula = PATHLENGTH ( SUBSTITUTE ( [ColumnName], "Word_to_search", "|" ) ) - 1
This is the M formula
=List.Count(Text.Split([ColumnName], "Word_to_search")) - 1
Below is the illustration of above formulas