Forum Discussion
v_mark
Helper V
Helper VExtact text from multiple Delimiters
I know there is a way to do this in Power Query but I am just wondering if there is an option in DAX primarily in a calculated column. Currently my data looks like this . Thanks in advance! ...
Ashish_Mathur
Super User
Super UserHi,
Try this calculated column formula
Column = mid(Data[Code],SEARCH(" - ",Data[Code],,0)+3,50)It does not work for the third one, because that symbol is not a -.