Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

How many times a word occurs in a cell

06-09-2019 03:11 AM

Zubair_Muhammad
Community Champion
1441 Views
Zubair_Muhammad
Community Champion
Community Champion

How many times a word occurs in a cell

‎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

 

 

No_of_times.png

 

 


Regards
Zubair

Please try my custom visuals
Preview file
34 KB
HowManyTimesWordAppearsInACell.pbix
Labels:
Message 1 of 1
1,441 Views