Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

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:
Anonymous's avatar
Anonymous
Not applicable
3 years ago

thank u. once again