Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Steg
Helper I
Helper I

how to make a new column and combine names

I have a table with names of employees. There are several names of persons in the list that refers to the same persons, but are written diverently (at least  on incorrect) (column 1). how can I make a new column (column 2) where I combine the right and wrong names. 

 

column 1 column 2
smithhas to besmith
cooperhas to becooper
meyerhas to bemeyer
meijerhas to bemeyer
1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi @Steg ,

 

Suppose that you have a table with the correct names:

vkellymsft_0-1628474894165.png

Then go to power query>click "merge queries as new" under Home button:

vkellymsft_1-1628474945017.png

 

Then check "Using fuzzy matching" with a similarity of 0.5(You can set a higher similarity if needed):

vkellymsft_2-1628475038563.png

And you will see:

vkellymsft_3-1628475082990.png

You could also check the reference below:

https://radacad.com/fuzzy-matching-in-power-bi-and-power-query-match-based-on-similarity-threshold

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

  

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi @Steg ,

 

Suppose that you have a table with the correct names:

vkellymsft_0-1628474894165.png

Then go to power query>click "merge queries as new" under Home button:

vkellymsft_1-1628474945017.png

 

Then check "Using fuzzy matching" with a similarity of 0.5(You can set a higher similarity if needed):

vkellymsft_2-1628475038563.png

And you will see:

vkellymsft_3-1628475082990.png

You could also check the reference below:

https://radacad.com/fuzzy-matching-in-power-bi-and-power-query-match-based-on-similarity-threshold

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

  

This is extremely helpful. thank you so much

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.