Forum Discussion
Data cleaning
Hello!
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:
| PROJECTNUMBER | BUILDING |
| 10001 | ["New","Rehab","Annex"] |
| 10002 | ["New"] |
| 10003 | ["New","Rehab"] |
| 10004 | ["New"] |
| 10005 | ["Rehab","Vehicles"] |
Is there any DAX formula to remove this -- [""] from the values to get the following output?
| PROJECTNUMBER | BUILDING |
| 10001 | New,Rehab,Annex |
| 10002 | New |
| 10003 | New,Rehab |
| 10004 | New |
| 10005 | Rehab,Vehicles |
Regards
Priya
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
2 Replies
In Power Query Editor , in you can replace values .
Follow the steps , First remove the Double Quotes and then Squre Brackets
Vijay
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
