How many times a word occurs in a cell 06-09-2019 03:11 AM

[Zubair_Muhammad]

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