Forum Discussion
Best Resource for learning M language?
ImkeF - I know this is a question for you - and anyone else who might have some ideas.
I put it on the forum in case someone else would be interested in the info also.
What resources, books, etc... would you recommend for learning M? Some of my reports I can use DAX and it be just fine, but as you know - there are others that require M - and have requirements that DAX can't meet.
My reports are only getting harder - so I figured it was time to bite the bullet and start teaching myself M. :) Any thoughts?
EDIT: this was the only book I've found so far - but I wanted to get your recommendations first before I just start buying books.
I've put together some learning ressources on my website here: http://www.thebiccountant.com/learning-resources/
The book you've mentioned is very good in my eyes. It is best suited for the Excel-user, and espacially at the beginning tries to do as much as possible with the UI. So if you don't have a strong IT-background this is the best start in my eyes.
But it is different if you want to learn M as a language. This approach might better suit those who come from a more technical background. Then I'd recommend to start with the Quick Intro on MSDN or the video.
Apart from that: I can recommend anything on that page. The more you read the easier you understand :-)
7 Replies
I've put together some learning ressources on my website here: http://www.thebiccountant.com/learning-resources/
The book you've mentioned is very good in my eyes. It is best suited for the Excel-user, and espacially at the beginning tries to do as much as possible with the UI. So if you don't have a strong IT-background this is the best start in my eyes.
But it is different if you want to learn M as a language. This approach might better suit those who come from a more technical background. Then I'd recommend to start with the Quick Intro on MSDN or the video.
Apart from that: I can recommend anything on that page. The more you read the easier you understand :-)
Hi Imke,
thank you so much for putting together learning resources on your blog.
I was wondering if you are aware of any resources for beginners who want to learn scripting in M from scratch? (very much like on Codecademy, Treehouse or Code.org) I've just read Rookie to Rockstar and M is for Data Monkey which are great resources for starters, both provide little insights into actually writing code in M though.
Thanks,
Rafael
I think this is the only best reference
https://msdn.microsoft.com/en-us/query-bi/m/understanding-power-query-m-functions
Thanks,
Rema
Thanks for sharing your website!
When it comes to choosing the best language learning resource, a lot depends on your goals and learning style. Personally, an integrated approach suits me best when grammar, vocabulary and phonetics are combined. One of the best resources I've found for this is the https://promova.com/app/french-language-learning-app website. Here you can find lessons with interactive exercises that help you better understand the structure of the language and improve pronunciation. It is especially useful that the lessons are adapted to different levels of language proficiency, from beginners to advanced.
