I'm trying to remove both open " ( " and close " ) " parenthesis in a word containing both of them.
I want it to be:
I cannot seem to find the correct DAX formula to remove both the open and close parenthesis.
Appreciate if you can help me.
Go to Solution.
Place this into a new column and change the TableName & ColumnName to suit
Remove Parenthesis = SUBSTITUTE (SUBSTITUTE ( 'TableName'[Column Name], "(", "" ),")","")
Thanks @idrabble (Ian). It works!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.