Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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