how to extract the text before delimeter

[YASHASHRI]

Hi all,
I have a list of values and I want to separate the value by the delimeter so here is one example.

ex: yashashri.dhaware (analyst)
     abcde (engineer )

so I want a result as -->  yashashri.dhaware
                                        abcde

Help me with theses.
Thanks

[tamerj1]

Hi @YASHASHRI 

please try

Extracted =
PATHITEM ( SUBSTITUTE ( [your text measure], " (", "|" ), 1 )

[some_bih]

Hi @YASHASHRI  check 

https://radacad.com/extract-parts-of-a-text-value-in-power-bi-using-a-delimiter-power-query-transfor... 

and https://learn.microsoft.com/en-us/powerquery-m/text-beforedelimiter 

[YASHASHRI]

Dataset that I have is taken by direct query hence i cant do the operation in power query editor.
want a dax for that.