DAX to extract all the characters after a particular STRING

[ak77]

Hi All ,

is there a DAX formula to get all the characters before a particular string? please let me know

For Ex: in the below string i need to extract words before Benchmark

TOTAL EQUITY Benchmark
PRIVATE EQUITY  Benchmark
EMERGING POOL Benchmark 

Output:

TOTAL EQUITY
PRIVATE EQUITY
EMERGING POOL

[ak77]

@Ahmedx Thanks !. perfect solution.

[Ahmedx · Accepted solution]

or

Column = 
VAR __t = SEARCH(" Benchmark",[Column1],1,0)-1
RETURN
LEFT([Column1],__t)

[Ahmedx]

pls try this

Column = 
VAR __t = SUBSTITUTE('Table'[Column1]," Benchmark","|")
RETURN
TRIM(PATHITEM(__t,1,TEXT))