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

[nikkollai]

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)
https://www.youtube.com/watch?v=bKmxFhOY70M


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

Tks, N -

 

[Kazlik]

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
)