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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
v_mark
Helper V
Helper V

Extact text from multiple Delimiters

I know there is a way to do this in Power Query but I am just wondering if there is an option in DAX primarily in a calculated column. 

Currently my data looks like this . Thanks in advance!

 

CodeExpected result
BSA06 Test North - 19C19C
ASA01 Test-ABC - 32B32B
ESA05 NotReal – 1515
TSA01 Awesome Rural - ProvProv
3 REPLIES 3
Ahmedx
Super User
Super User

try to write like this

Text.Trim(Text.Range(
  [Code], 
  Text.PositionOfAny(
    [Code], 
    {Character.FromNumber(8211), Character.FromNumber(45)}, 
    RelativePosition.FromEnd
  )
    + 1
))

Screen Capture #662.pngScreen Capture #663.png

Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhkhamWLt92LapWi6?e=vnoowN

 


 

Ashish_Mathur
Super User
Super User

Hi,

Try this calculated column formula

Column = mid(Data[Code],SEARCH(" - ",Data[Code],,0)+3,50)

It does not work for the third one, because that symbol is not a -.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
ribisht17
Super User
Super User

@v_mark 

 

Please check this post and solution https://community.powerbi.com/t5/Desktop/Splitting-Text-on-multiple-delimiters-with-DAX/m-p/2480035

 

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors