Trim a string before a character

[Anonymous]

Hi Experts,

I have a column which have a string as the below. I want to have a DAX formula to truncate the text on the first Semi-Colon ":"

Rohde & Schwarz GmbH & Co. KG: Q42 FY22 MaintRenew: SO#: 9990

Result would be: 

Rohde & Schwarz GmbH & Co. KG

[VahidDM · Accepted solution]

Hi @Anonymous 

Try this code to add a new column:

Column = 
Var _SR = SEARCH(":",'Table'[Data])

return
left('Table'[Data],len('Table'[Data])-_SR-2)

or this code to add a new measure:

measure= 
Var _SR = SEARCH(":",max('Table'[Data]))

return
left(max('Table'[Data]),len(max('Table'[Data]))-_SR-2)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/