Forum Discussion

ktt777's avatar
ktt777
Icon for Helper V rankHelper V
2 years ago
Solved

Define potential duplications

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.