M is the powerful language behind the scene of Power Query. Any transformation you apply will be written in M language. For many, M looks like a scary language. In this video, I would like to explain some of the basics of M without mentioning any functions. Mainly, I want to explain to you how the M language syntax is structured. Once you know the syntax, then everything becomes simple. M is a language whose syntax you can learn easily. As a Power Query developer, I highly recommend you spend time on M because there are MANY operations you can do with M, but you might not be able to do it simply with the graphical interface.
Learn more from my blog article here:
https://radacad.com/basics-of-m-power-query-formula-language