Skip to content

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

Photo of Alan Murray
Hosted By
Alan M. and Tea K.
Power Query Magic: Crafting a Custom Splitter from Scratch | Melissa De Korte

Details

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:
https://www.linkedin.com/in/melissa-de-korte-64585884/
https://www.amazon.com/Definitive-Guide-Power-Query-Transformation/dp/1835089720

Links to attend the event on Zoom or YouTube will appear closer to the event.

The event is recorded on the Computergaga YouTube channel.
RSVP to this event to receive the recording and other event communication.

See you all there.

Photo of London Excel Meetup Group group
London Excel Meetup Group
See more events
FREE