Define potential duplications

[ktt777]

Hi all,

i have a list of entries that was manually entered. There are potential duplications in there.

For example : Star Pte Ltd , Star Pte. Ltd, Stars Pte Ltd

Any way to define the list of the potential duplications ?

Thanks,

[v-jiewu-msft · Accepted solution]

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.

[ktt777]

Thank you. Fuzzy matching usually needs 2 columns to match. What if i only have the original data with name variation without the standard data to compare

[rajendraongole1]

Hi @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!!