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
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.