Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How do I find exact text within a string?

Hello,   As always, I apologise if this is common knowledge within Power Bi.   How do I go about finding & counting exact text, within a string-- For Example, I want to find comments that contain...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Try this

Column = CONTAINSSTRINGEXACT([Column1],"TU")|| CONTAINSSTRINGEXACT([Column1],"BU")

CONTAINSSTRINGEXACT returns True/False. How do you want to count?

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

 

Sorry for my delayed response, I have not had access to the site.

 

Ideally I would like to count each incident where "TU" or "BU" appears in a comment/ text string, but only count once if one of them appears within a sentence. The Original formula and the one accepted as a solution- Counts 2 if TU & BU appear in the same text string as opposed to 1.

 

I hope I have coveyed my message well!

 

Kind regards,


Alex