Column to show string groupings

Hi MichaelHutchens ,

Create a copy of the table by duplicating the table in Power query.

Perform Fuzzy Merge - Self-Join

• Go to Files table.
• Home > Merge Queries > Merge Queries as New
• Primary table: Table
• Secondary table: Duplicated Table
• Join on File Name using Fuzzy Matching:
• Check Use fuzzy matching
• Click Fuzzy matching options:
• Similarity threshold = tweak as needed
• check ignore case
• Max matches: blank

In the merged table, remove duplicates so each pair appears only once by using Table.Distinct

Create a group ID table using DAX to assign a group ID to every file participating in a fuzzy match. You can then join it back to your original file list, and if any file name is not present in the Grouping table, assign that group to 0.

If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.

Regards,
Chaithra