Forum Discussion
Solved
Merge query adjusting total numbers
I created a merge query in Power BI with left outer and fuzzy matching to perform the merge. The merge matched 21,853 out of 21, 953 records in my data set, this was an accurate number based on null ...
Hi jwittkopp ,
I think it is cause by enabling fuzzy matching. It will match some similar data with the same value. You could reference the blogs to create a transformation table when use the option to merge table more accurate.
Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold
That's almost impossible to say. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490