Forum Discussion
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
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:
2 Replies
FreemanZSuper 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: