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! ...
try to write like this
Text.Trim(Text.Range(
[Code],
Text.PositionOfAny(
[Code],
{Character.FromNumber(8211), Character.FromNumber(45)},
RelativePosition.FromEnd
)
+ 1
))Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhkhamWLt92LapWi6?e=vnoowN