Forum Discussion

mspreng's avatar
mspreng
Frequent Visitor
8 years ago
Solved

Lookup table in combination with searching a text string

Long time lurker, first post, hi!   I have a table with some billing data and an ID. The ID column has the format xxx/[name]/xxx... OR xxx/yyy/zzz/[name] and the [name]'s in this ID string may or m...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey mspreng

     

    Your situations seems pretty interesting, but I've done a video on something very similar to this that I think might help you out. I don't have the exact link right now but if you go to youtube.com/c/bielite you can search for the "VLOOKUP" video I did a couple weeks back. The gist is to use the CONCATENATEX function to loop through all of your potential names and then the SEARCH function like you have already done.

     

    Hope this helps,

    Parker

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey mspreng

 

Your situations seems pretty interesting, but I've done a video on something very similar to this that I think might help you out. I don't have the exact link right now but if you go to youtube.com/c/bielite you can search for the "VLOOKUP" video I did a couple weeks back. The gist is to use the CONCATENATEX function to loop through all of your potential names and then the SEARCH function like you have already done.

 

Hope this helps,

Parker

ECE's avatar
ECE
Icon for Advocate II rankAdvocate II
6 years ago

Hi Anonymous,

 

Very nice solution !
Any chance you know how we can accomplish this in Power query rahter than in DAX?

I have searched all over, but haven't been able to find a solution, where we are "looking up" text values, in the same way the lookup works in Excel.

In Excel we can lookup approximate text values using this formular:

=Lookup(2^15,Find('Sheet1'!$M$4:$M$21,$J7),'Sheet1'!$O$4,$O$21)

 

Thanks in advance,

Espen