Forum Discussion
undefined
rubayatyasmin i need output as text without the bracket ex : Head Office I used to write the code Right ( dim( customer) , search("(" , dim( customer) 1, len ( dim( customer )+1)-1) ...
Hi, Karthikgayathri
Go to power query and use Split by Delimiter. Set the delimiter to (, it will split it in a new column. Rename the column. this kind of changes fall under data transformation. No need to write DAX for it. Power Query has it's own functionality to handle these sort of stuff.
Refer to this document : https://learn.microsoft.com/en-us/power-query/split-columns-delimiter
Bro I need dax formula by using left ,right ,mid functions
