Tag Archives: Join

  • Fuzzy Matching in Power BI / Power Query

    image

    A long awaited post! The Fuzzy matching preview feature was added to Power BI Desktop MONTHS ago and here’s my take on it.

    What is Fuzzy Matching?  In short, it’s an algorithm for approximate string matching.

    Why does it matter? Up until September of last year, Power BI / Power Query only gave us the option (natively) to do Merge / JOIN operations similar to a VLOOKUP (FALSE) where we can only do exact matches. That has changed and we can do now “close” or “approximate” matches thanks to Fuzzy Matching

    What can I do with it? Let me give you a practical example of something that I recently had to do!