Every time I use the Power Query interface, I am aware that I am writing code that is probably as inefficient as recorded VBA code.
Today, a new book from Mike Girvin will teach you how to write M code in Power Query. This is for Power Query in Excel, Power BI, or Power Automate.
The book will be shipping from Amazon on October 1, 2024. However, by the third week in August, I am going to have 200 advance copies. For $29.95, you can buy one of these books with free shipping to the USA. While you wait, you can download the PDF immediately.
If you are outside of the USA, you can buy just the PDF today for $14.99. Or, wait until October 1, 2024 when your local Amazon should have the book available.
Buy from here: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/