cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
priyadarshiniv Frequent Visitor
Frequent Visitor

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:

PROJECTNUMBERBUILDING
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?

 

PROJECTNUMBERBUILDING
10001New,Rehab,Annex
10002New
10003New,Rehab
10004New
10005Rehab,Vehicles

 

 

Regards

Priya

1 ACCEPTED SOLUTION

Accepted Solutions
danderson2692 Regular Visitor
Regular Visitor

Re: Data cleaning

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

2 REPLIES 2
Highlighted
VijayP Regular Visitor
Regular Visitor

Re: Data cleaning

In Power Query Editor , in you can replace values .

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

Vijay

2019-07-15_130346.jpg2019-07-15_130459.jpg

danderson2692 Regular Visitor
Regular Visitor

Re: Data cleaning

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,868)