Forum Discussion
Helper VDefine potential duplications
Hi ktt777 ,
Based on the description, try to create a new column for standardization.
Standard = LOWER(TRIM(SUBSTITUTE([Name], ".", "")))You can also viewing the following documents to learn more information.
TRIM function (DAX) - DAX | Microsoft Learn
SUBSTITUTE function (DAX) - DAX | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHi ktt777 -in power query editor you can check the fuzzy matching technique. This approach helps to find similarities between strings that are not exact matches but likely refer to the same entity.
In your case, where variations in company names might exist due to abbreviations, punctuation, or slight differences.
Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!