Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

partial match url using search function

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.g...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    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.

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
6 years ago

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?