Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SplitText by variable number of backslashes DAX Measure

Hi All,   Need help with my DAX. I need to be able to extract just the "Sprint ##" part from my text field   My text field format can be like any of the below examples   Team_Name\Project Name\...
Need Help
  • AnkitBI's avatar
    AnkitBI
    6 years ago

    Hi  Anonymous  It seems some kind of Bug in system. Find function is working fine if we are giving optional 4th parameter for "NotFoundValue" value. Please try below. Change "-1" as per you deem fit.

    https://docs.microsoft.com/en-us/dax/find-function-dax

     MID([IP_Sprint],FIND("@",[IP_Sprint],1,-1)+1,10) 

     

    Thanks
    Ankit Jain
    Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.

     

     

     

     

    Anonymous

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
6 years ago

Hey Anonymous ,

 

maybe you can adapt this formula to your needs:

PATHITEMREVERSE(SUBSTITUTE('Table'[the string] , "\" , "|") , 1 , TEXT)

The function SUBSTITUTE replaces all "\" with "|". The pipe sign | is used as a separator by all the PATH... functions. Then PATHITEMREVERSE takes the last item, by counting backwards.

 

Regards,

Tom