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.

Share this:
Brian Grant
Brian Grant
briang@cgspro.com

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.