Data cleaning

[Anonymous]

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

[VijayP]

In Power Query Editor , in you can replace values .

Follow the steps , First remove the Double Quotes and then Squre Brackets

Vijay

[danderson2692 · Accepted 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