How to count number of words in a column and not character

[Dee]

Hi all,

I am trying to find the number of names in a column and not the actual characters.

eg

John Doe = 2

 John Doe = 7

Is there dax for a word in a text count and not only characters?

TIA

[mahoneypat]

In case it helps, it is also possible to do this in query with M code too.  For example,

List.Count(Text.Split("John Doe", " "))  would equal 2.  You would use your column name in place of "John Doe".

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Greg_Deckler]

So, potentially, this is the way I do these kinds of things:

Words Column Counter = 
  VAR __Length = LEN('Table'[Column])
  VAR __Text = SUBSTITUTE('Table'," ","")
RETURN
  __Length - LEN(__Text)

[Dee]

Hi @Greg_Deckler I seem to get an error with the following message:

 The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

[Greg_Deckler]

@Dee My bad, I corrected it below. Also included measure form.

Words Column Counter = 
  VAR __Length = LEN('Table'[Column])
  VAR __Text = SUBSTITUTE('Table'[Column]," ","")
RETURN
  __Length - LEN(__Text)

Words Column Measure = 
  VAR __Length = LEN(MAX('Table'[Column]))
  VAR __Text = SUBSTITUTE(MAX('Table'[Column])," ","")
RETURN
  __Length - LEN(__Text)

[harshnathani]

@Dee ,

Please watch the below video by @ruthpozuelo .

It separates your name into two separate column using DAX. 

In your case you can just count the no. of space between words to get the total words.

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!