Forum Discussion
PATHITEM function to extract string from the URL
To ensure that queries sent to the underlying data source have acceptable performance, limitations are imposed on measures by default. Advanced users can choose to bypass this limitation by selecting File > Options and settings > Options and then DirectQuery, then selecting the option Allow unrestricted measures in DirectQuery mode.
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery#limitations-of-directquery
i have turned on that option, it is still not working.
I have tried MID and SEARCH functions, I'm getting error message "Search" and "Find" are not allowed as part of calculated column DAX.
As per the link below: we need to use 4 argumnet instead of 2 argument.
http://community.powerbi.com/t5/Desktop/FIND-SEARCH-in-direct-query-mode/td-p/198993
I'm trying that option but still not luck.
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