Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Extract text after delimiter using DAX

Hi everyone, I am trying to write a DAX code to extract the text after delimitter.  Example Dataset:  Charge Code Expected Output AON05-0009-EI EI AON008-S S BT01-0002-EL EL   ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • coskuersanli's avatar
    coskuersanli
    4 years ago

    Hi Anonymous 

     

    In Power Query, you have an option to split at right most delimiter. Would it solve your problem?

     

     

coskuersanli's avatar
coskuersanli
Resolver III
4 years ago

Hi Anonymous 

 

In Power Query, you have an option to split at right most delimiter. Would it solve your problem?

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi coskuersanli  thanks this worked!! I was not aware of this function.