Forum Discussion
Difference between Excel fuzzy vs Power BI fuzzy
Hi Everyone,
I know Fuzzy match is available on PowerBI now and I am wondering if this is a better logic(higher accuracy) of Fuzzy than Excel? I used to do it in Excel and if Power BI is better, I would like to switch.
Thanks in advance,
Wilson
- Anonymous7 years ago
Hi Anonymous,
AFAIK, current power bi not support direct use specific match symbol in filter.
You can take a look at following blog to know how to use left, right functions with search function to achieve fuzzy match.
From SQL to DAX: String Comparison
Regards,
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
Hi Anonymous,
AFAIK, current power bi not support direct use specific match symbol in filter.
You can take a look at following blog to know how to use left, right functions with search function to achieve fuzzy match.
From SQL to DAX: String Comparison
Regards,
Xiaoxin Sheng