Power Query Magic: Crafting a Custom Splitter from Scratch | Melissa De Korte

In this meetup, we have Melissa De Korte showcasing some Power Query Magic.

Description:
Let's tackle a real head-scratcher together: what to do when standard M functions just don't cut it, especially with the pesky case sensitivity issue in Power Query. If you've ever found yourself wrestling with the need to split data but dreaded the thought of messing up your letter casing to achieve it, this session has got you covered. We will build a custom splitter that tackles case variations with ease. This is for all data heroes out there who are looking to overcome these types of limitations, expanding their toolkit with a shiny new tool and the know-how to wield it. Get ready to level up your data game!

About:
Melissa de Korte is a passionate problem-solver known for her ability to simplify complex problems with Power Query and M. With an impressive track record as an Enterprise DNA Expert and Fabric Community Super User, Melissa has become an asset to the data community, actively engaging, supporting, and inspiring others.
She posts regularly on LinkedIn using the hashtag #pqtodaysmenu and is co-author of "The Definitive Guide to Power Query (M)," a comprehensive resource essential for both beginners and seasoned professionals. Her work demystifies complex concepts and empowers users to harness the full potential of Power Query and the M language.
Connect with Melissa:
  / melissa-de-korte-64585884  
https://www.amazon.com/Definitive-Gui...

This is an online event and starts at 18:00 GMT + 1.

Join London Excel Meetup Events
https://www.meetup.com/london-excel-m...

Learn more Excel and Power BI
https://computergaga.com

#powerquery #excel #londonexcelmeetup