I have an issue in data. From one of the application I am loading project related information in DIM_PROJECT (SQL table). But few columns has following format:
Is there any DAX formula to remove this -- [""] from the values to get the following output?
Go to Solution.
If you want to do this through DAX instead of the query editor, you can use substitute() https://docs.microsoft.com/en-us/dax/substitute-function-dax
View solution in original post
In Power Query Editor , in you can replace values .
Follow the steps , First remove the Double Quotes and then Squre Brackets
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!