Removing Open and Close Parenthesis in Text

[markefrody]

Hi,

I'm trying to remove both open " ( " and close " ) " parenthesis in a word containing both of them.

Example:

(New Message)

I want it to be:

New Message

I cannot seem to find the correct DAX formula to remove both the open and close parenthesis.

Appreciate if you can help me.

Thanks!

Best regards,

Mark

[idrabble · Accepted solution]

Place this into a new column and change the TableName & ColumnName to suit

Remove Parenthesis = SUBSTITUTE (
SUBSTITUTE ( 'TableName'[Column Name], "(", "" ),
")",
"")

Ian

[markefrody]

Thanks @idrabble (Ian). It works!