Count Occurrences of ";" in Cell

[joe100]

Guys, 

Please your help to write a DAX expression that gets a value from each row and count delimiters.

The delimiter can be ";", " " or ",".

Thanks in advance

[SanketBhagwat · Accepted solution]

Hi @joe100 .
Not sure about DAX, but you can do it in Power Query.
Just create a custom column using formula as below;

List.Count(Text.ToList(Text.Select([Column], ";")))

Let me know if it works.
Thanks,
Sanket.

If this post helps, then give it a 👍 and mark it as 'Accept as Solution'.

[SanketBhagwat · Accepted solution]

Just replace the ;  from that formula with "," or " " as per your requirement.

If this post helps, then give it a 👍 and mark it as 'Accept as Solution'.

[CNENFRNL · Accepted solution]

= List.Count(Text.PositionOfAny("abc,def shkd;22l3f oiw;d", {";"," ",","}, 2))

[joe100]

In my case it's:

List.Count(Text.PositionOfAny([ID], {";"," ",","}, 2)))

Awesome! This works for me, many thanks.

Is there an option to add also "NewLine" delimiter?

[SanketBhagwat · Accepted solution]

Hi @joe100 .
Not sure about DAX, but you can do it in Power Query.
Just create a custom column using formula as below;

List.Count(Text.ToList(Text.Select([Column], ";")))

Let me know if it works.
Thanks,
Sanket.

If this post helps, then give it a 👍 and mark it as 'Accept as Solution'.

[joe100]

Thank you, it works!

How I extend it also for "," and " "?

[SanketBhagwat · Accepted solution]

Just replace the ;  from that formula with "," or " " as per your requirement.

If this post helps, then give it a 👍 and mark it as 'Accept as Solution'.