cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ijheyburn Frequent Visitor
Frequent Visitor

Return string after occurence of specific text

Afternoon All

 

I wonder if any kind person could perhaps suggets the relevant DAX I would need to add a calculated column.

 

I would like the DAX to search a field for the occurence of the word Asset and where that word occurs I would then like the next string of text/numbers returned before the next space occurs (bearing in mind there is likely a space between the word asset and the string I would then like to return).

 

I hope that makes sense!

1 ACCEPTED SOLUTION

Accepted Solutions
guicaol Visitor
Visitor

Re: Return string after occurence of specific text

CONTAINSSTRING has the same function LIKE in SQL, so you in indetify the index of the colonunm, the next steps is using the index for return string 
1 REPLY 1
guicaol Visitor
Visitor

Re: Return string after occurence of specific text

CONTAINSSTRING has the same function LIKE in SQL, so you in indetify the index of the colonunm, the next steps is using the index for return string 

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 42 members 948 guests
Please welcome our newest community members: