Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreThe FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now
Your file has been submitted successfully. We’re processing it now - please check back in a few minutes to view your report.
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