i am trying to do a partial match of url,similar to vlookup in excel.any idea how to do it in powerbi?
any advice is appreciate. Thank you.
Go to Solution.
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.
View solution in original post
Hi @mellyVK ,
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.
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?
@helassal hi, i am trying to do similar to a vlookup in powerbi, can it return the value of "ABC" instead of "ZZZ"?
i got this error when i applied to the 10000+ of messy urls i had...
is there any way to avoid the errors?
This means that there are duplicates appearing in the URL column of the urltable Table. Remove those duplicates.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!