22-25 April 2026 
SQLBits 2020
Power Query formule language M for beginners
M is the formula language behind Power Query. Any transformation you apply to your data is translated into M code. Knowledge of this language opens doors that remain closed if you only use the GUI.
M is the formula language behind Power Query. Any transformation you apply to your data is translated into M code. Knowledge of this language opens doors that remain closed if you only use the graphical interface.
In this demo packed session I will show you what else is possible by using the Advanced Editor, such as:
- Working with variables and data types
- Custom Columns and Time Intelligence Filtering
- Grouping and sorting data
- Creating scalar and table functions
- Crossjoin between 2 tables (make all possible combinations)
In the latest Power BI Desktop version the Advanced Editor also has Intellisense, so now is the time to dive into M!
Speakers
Arthur Graus's previous sessions
Master Python in Fabric for Data Engineers
The world of data engineering is changing and being fluent in T-SQL is not enough anymore. In this full day workshop with lots of exercises you will get up to speed with Python and learn all the tips and tricks you need to know.
Python in Fabric for Data Engineers: all you need to know
The data engineering landscape is evolving. T-SQL proficiency isn't enough now. Dive into modern tools like Delta Lake, Jupyter Notebooks, and MS Fabric with Python. This session covers Python syntax, Jupyter in Fabric, data manipulation with Pandas, PySpark for Big Data, and data extraction/loading techniques for various formats.
Power Query formule language M for beginners
M is the formula language behind Power Query. Any transformation you apply to your data is translated into M code. Knowledge of this language opens doors that remain closed if you only use the GUI.