M365 Show -  Microsoft 365 Digital Workplace Daily

M365 Show - Microsoft 365 Digital Workplace Daily

Microsoft Data Pulse: Power BI, Fabric, Purview

How to Use Fuzzy Merge in Power Query for Similarity-Based Data Matching

Mirko Peters - M365 Specialist's avatar
Mirko Peters - M365 Specialist
Jun 18, 2025
∙ Paid

If you ever need to match up records that almost—but don’t quite—look the same, Fuzzy Merge makes it easy. You can join customer or department data, even if the text entries have typos or different formats. For example, a marketing team once merged over 2,000 duplicate CRM records in just 15 minutes, and a financial firm processed a million records in u…

User's avatar

Continue reading this post for free, courtesy of Mirko Peters - M365 Specialist.

Or purchase a paid subscription.
© 2026 Mirko Peters · Publisher Privacy ∙ Publisher Terms
Substack · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture