Hi everyone. There are some really interesting ideas in this thread, thanks for your vocal support about it! We’ll consider it for the future along with other suggestions and plans. Thanks!
We can surely benefit from this request
Thanks for the suggestion. We will consider this and prioritize against other ideas.Robert Erickson supported this idea ·
256 votesunder review · 27 comments · Power BI Ideas » Data Preparation · Flag idea as inappropriate… · Admin →
Great - waiting to test it
For either a Power Query function or a new DAX function, we could use a fuzzy string compare to provide a score like 1 to 10 of the similarity of a string. I believe that SSIS has some functionality like this. For example we often has Company Names that we need to match to an external source and would like to get a score to compare names like "Wal-Mart", "WalMart","Wal*Mart", "Division or Wal*Mart", "Wal-Mart Stroes", etc. Does anyone else need this type of compare - or found a simple way to do it in Power Query?