Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 compatibilty in DirectQuery mode.
Example:
URL: /country/english/pages/careers/article
I want to extract "careers" in new column.
DAX formula is working fine: PATHITEM(SUBSTITUTE(COLUMN,"/","|"),5)
Could you please help me with the function to do the same for direct query
Thanks
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.
The nested FIND Function seems to work for me.
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
Specify the fourth parameter NotFoundValue as well.
When i try to use 4th parameter, I'm getting a error message saying i have used many arguments.
Thanks,
Sri
Hi Sam,
Could you please help me with this.
Thanks,
Sri
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |