Forum Discussion
Extact 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! ...
Hi,
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 -.