Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Len dax calculated column measure to split text column

Hi Experts

 

I cannot use the Power Query option here as my sharepoint list url is plying up..... 

 

I need to split the data in image below less ["  and  "] so i just see order Picking only jus the text 

 

BlueWhite111_0-1671014508828.png

 

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

Hi @Anonymous 

You may try this with DAX, try to add a column with this:

Column = SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Example],UNICHAR(34),""), "[",""), "]", "")
 
I tried and it worked like this:
FreemanZ_0-1671023740242.png

View solution in original post

2 REPLIES 2
FreemanZ
Super User
Super User

Hi @Anonymous 

You may try this with DAX, try to add a column with this:

Column = SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Example],UNICHAR(34),""), "[",""), "]", "")
 
I tried and it worked like this:
FreemanZ_0-1671023740242.png
Anonymous
Not applicable

thank u. once again

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors