Forum Discussion
Fuzzy grouping
To work on some tables, I found it useful to use the Table.FuzzyGroup function. Unfortunately the result of the tests carried out is different from what I would have expected. In particular, the T...
Anonymous Have used it, has some limitations around just how much control you have over it. Yes, the order matters I believe as well as the threshold as I think the way the algorithm works is that it finds the first match that falls within the threshold essentially. Hard to know for certain as it is kind of a black box.
If you want more control, I did create this DAX Fuzzy matching Quick Measure Gallery submission here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Fuzzy/m-p/1352914#M608