fuzzy_group
Combine rows with similar key values to resolve typos and casing, then apply aggregations like sum, count, average. Adds Table.FuzzyGroup to Power Query M.
Instructions
Power Query Fuzzy Group By: collapse rows whose key values are APPROXIMATELY equal (typos/casing) into one group with aggregates. Appends Table.FuzzyGroup to the table's M query. keyColumns is comma-separated. aggregations is comma-separated as name:op[:column] (op = Sum | Count | Average | Min | Max | CountDistinct | All). threshold is the optional 0..1 similarity cut-off.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| sessionId | Yes | ||
| threshold | No | similarity threshold 0..1 (optional) | |
| keyColumns | Yes | the grouping key columns, comma-separated | |
| aggregations | Yes | aggregations as name:op[:column], comma-separated | |
| partitionName | No | partition name (optional; defaults to the first partition) |