# Partial or Fuzzy Match inside PowerPivot (DAX alternative to 2^15)

#### nikkollai

##### New Member
Hello Dear Friends,

I think most of the people faced with fuzzy match (partial match) problem found the following tutorial posted by Mike Girvin ExcelIsFun) and discovered a surprisingly interesting solution that starts with = LOOKUP(2^15(SEARCH(.......

Here is the url to the video tutorial:
Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)

I was wondering is there a similar solution that could be achieved with DAX inside PowerPivot. I will highly appreciate your ideas.

Tks, N -

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
not sure if this will help but I use this for checking the title field for certain text values that are in a lookup table

=FIRSTNONBLANK(FILTER(
VALUES(Lookup[Values]),
SEARCH(
Lookup[Values],
Coverage[Title],
1,
0
)
)
,1
)

Replies
5
Views
325
Replies
0
Views
469

1,196,497
Messages
6,015,550
Members
441,900
Latest member
Inaschemitex2023

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back