Forum Discussion

harsha449's avatar
harsha449
Frequent Visitor
8 years ago

PATHITEM function to extract string from the URL

Hi,   I'm trying to extract string from the URL using PATHITEM function, it is working fine for DAX when the data is in excel.   Now I'm connect to direct query, i need to use DAX formula compati...
Show and Tell
Tips and Tricks
harsha449's avatar
harsha449
Frequent Visitor
8 years ago

Thanks Sam for looking into it.

 

=MID(H5,SEARCH("pages/",H5,1)+5,(SEARCH("/",H5,SEARCH("pages/",H5,1)+6)-(SEARCH("pages/",H5,1)+5)))

 

Could you please help in editing it.

 

to get "Careers" in new column.

 

Regards,

Sri

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    harsha449,

     

    Specify the fourth parameter NotFoundValue as well.

    • harsha449's avatar
      harsha449
      Frequent Visitor
      8 years ago

      When i try to use 4th parameter, I'm getting a error message saying i have used many arguments.

       

      Thanks,

      Sri

      • harsha449's avatar
        harsha449
        Frequent Visitor
        8 years ago

        Hi Sam,

         

        Could you please help me with this.

         

        Thanks,

        Sri