Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! 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
In Power Query Editor , in you can replace values .
Follow the steps , First remove the Double Quotes and then Squre Brackets
Vijay
Proud to be a Super User!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |