Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi all
i am trying to do a partial match of url,similar to vlookup in excel.
any idea how to do it in powerbi?
myurltable |
urlsource |
http://abc.com |
http://www.search.zzz.com |
www.global.mmm.com.au/about us |
mydata | |
url | Domain |
abc.com | ABC |
zzz.com | ZZZ |
mmm.com | MMM |
any advice is appreciate. Thank you.
Solved! Go to Solution.
Hi,
This calculated column formula in the url-list Table works
Column = LOOKUPVALUE(urltable[Domain],urltable[url],FIRSTNONBLANK(FILTER(VALUES(urltable[url]),SEARCH(urltable[url],'url-list'[URL],1,0)),1))
Hope this helps.
@Anonymous
This is the sort of thing Power Query is very good at: extracting segments from strings using delimiters.
Can' you do it in in Power Query?
Proud to be a Super User!
Paul on Linkedin.
Hi @Anonymous ,
I am afraid I am not able to follow, if possible, can you please add a descriptive statement of what you are trying to achieve, expected result and current result ? that will help us help you faster.
@helassal
hi, i am trying to do similar to a vlookup in powerbi, can it return the value of "ABC" instead of "ZZZ"?
Thank you.
Hi,
This calculated column formula in the url-list Table works
Column = LOOKUPVALUE(urltable[Domain],urltable[url],FIRSTNONBLANK(FILTER(VALUES(urltable[url]),SEARCH(urltable[url],'url-list'[URL],1,0)),1))
Hope this helps.
i got this error when i applied to the 10000+ of messy urls i had...
is there any way to avoid the errors?
Hi,
This means that there are duplicates appearing in the URL column of the urltable Table. Remove those duplicates.
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |