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…

This post is for paid subscribers

Already a paid subscriber? Sign in
© 2025 Mirko Peters
Publisher Privacy ∙ Publisher Terms
Substack
Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture