Combining Conflicting Customer Names Using Power Query

What is that customer’s name? Well, there are actually 3 of them. Maybe some of them are informal variations on a longer name (“Robert” becomes “Bob”), others might be from typos when the data was entered. Either way, you have to take a list of conflicting names for a customer and squeeze them into a single cell so you can see/search-for each and every version within your data. In this video Brian Grant will walk you through how you can leverage some more advanced features of the Power Query M language to achieve exactly that. He’ll show you both a longer method to help you understand the concepts and a shorter/faster method for when you want to get to the results you need quickly.

Click here to download the companion files

Share this:
Brian Grant

Brian Grant

Brian Grant is a masterful Senior Analytics Consultant by day, and a Power BI legend by night. A passion for Power BI drove him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. Brian is a constant teacher who leads Power BI training sessions, while sharing his wealth of expertise through video and blogging resources.
RELATED POSTS
Stay Connected

Subscribe to CSG Pro. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Search

Ready to wrangle your data?