This hands-on session walks you through a real-world data transformation case using Power Query. We will break down each line of M code to fully understand not only what it does, but why it’s written that way. The goal is to write clean, reusable, and dynamic code — and to gain a solid grasp of best practices for mastering the logic behind the M language.

Designed for professionals with an intermediate to advanced level in Power Query who want to move beyond the visual editor and dive into M scripting.

You will learn how to:

Work with lists, tables, records, and functions while avoiding hardcoding to create flexible and scalable solutions.

Write M code that is more readable, documented, and maintainable, by leveraging AI-powered tools to review, explain or optimize your transformations.

Focus on solving real-world problems, with a critical and professional approach to efficiency and code reuse.