Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Advanced searching within column text function wanted. Possible?

Hello all,

 

I am looking for something that is (I think) pretty advanced. I hope to hear from some great minds here if it is possible, and if yes, how?

 

Here is some easy sample data: https://www112.zippyshare.com/v/jOVh0GAu/file.html

Or here if the link does not work: https://filebin.net/9dqymvfrbafnumw3

 

The problem

In the data we see two columns, one which contains a call number, and one with a lot of strings all in one cell. In this cell we see a sample conversation between 3 persons. The middle persons says '#callcoaching'. This is the string I want to extract.

 

But not only that. I want to see who (the name) of the person who has said '#callcoaching', and the name of the first person that has initiated the call (the one that the coaching is meant to). The third one is just there to represent the real data, since the cells contain much more information than just 3 persons. There are dates and times before the names, these can be deleted if possible.

 

I want to show the total amount of instances where people have said the words '#callcoaching', which people are the most 'coached' (the first persons/call initiators) and which people use this phrase the most. I think we therefore need the have the data in separate columns, but I am not sure.

 

I have no idea if this is possible, but I hope someone here has an idea if this is doable in DAX or R or M or something.

 

Thanks for your time and effor.

AliBI

2 REPLIES 2
Mariusz
Community Champion
Community Champion

Hi @Anonymous 

Can not access your sample, is there any chance that you could share it any other way?

 

Many Thanks 

Mariusz

Anonymous
Not applicable

Thank you for the quick reply and sorry for the file not being accesible. How about this? https://filebin.net/9dqymvfrbafnumw3

 

Thank you,

AliBI

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.