These little tricks proved very helpful to me. I work with a set of data with varied sizes of event names but each event has a common string at the end of the event name. These tricks helped me use the left and search together to eliminate the extra string from the event names. Thank you for sharing your knowledge.
What if you have multiple delimiters in the text string? I have a text string column with 10 underscores that I want to pivot out each of the 11 pieces of text from those ten delimiters. I cannot use power query because it's a calculated table, so I need the right DAX code to peel out each text string from 10 delimiters.
What about the extraction of some sets of characters that are in different positions? I'm using CONTAINSSTRINGEXACT but having problems with the boolean results
Ordinarily, I would use an upstream solution like SUBSTRING() in SQL, however if you really needed to use DAX it may be quite complex. You could try to devise a more robust solution in Power Query with M code.
These little tricks proved very helpful to me. I work with a set of data with varied sizes of event names but each event has a common string at the end of the event name. These tricks helped me use the left and search together to eliminate the extra string from the event names. Thank you for sharing your knowledge.
It’s my pleasure, glad it was helpful!
Absolutely excellent, thank you.
very helpful, thanks a lot.
What if you have multiple delimiters in the text string? I have a text string column with 10 underscores that I want to pivot out each of the 11 pieces of text from those ten delimiters. I cannot use power query because it's a calculated table, so I need the right DAX code to peel out each text string from 10 delimiters.
What about the extraction of some sets of characters that are in different positions? I'm using CONTAINSSTRINGEXACT but having problems with the boolean results
Ordinarily, I would use an upstream solution like SUBSTRING() in SQL, however if you really needed to use DAX it may be quite complex. You could try to devise a more robust solution in Power Query with M code.
It helped, Thanks alot :)
Glad to hear, cheers Muhammad!