When getting started with Power Query the user interface works well for basic transformations. However, as your data preparation becomes more advanced, understanding the M language helps you create more flexible and robust queries.
In this video, I walk through five advanced Power Query tricks that you can apply in your own projects. Along the way, you will also see practical examples of how the M language works, helping you write and modify M code for more powerful data transformations.
If you want to work more efficiently in Power Query and level up your Power BI skills, this video is for you.