Solved: Get no of text string in Column

Anonymous · ‎06-16-2021

Hi,

I have a column that contains some text, and I want to find the no of a text string in it.
Eg

mahoneypat · ‎06-16-2021

You can add a custom column in the query editor with

= List.Count(Text.Split([Column], " "))

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

mahoneypat · ‎06-16-2021

You can add a custom column in the query editor with

= List.Count(Text.Split([Column], " "))

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Get no of text string in Column