cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 295 members 3,173 guests
Please welcome our newest community members: