How to expand your knowledge on M?

Hi everyone,

Now and again the question is raised on the forum on how to learn more about M. Tips for other online resources, books, video’s and so on. To centralize all these bits and pieces of information @BrianJ rightfully suggested to post it here and make it easier for anyone to find and contribute :+1:
.

My ‘general’ Best practices for how to expand your knowledge on Power Query M are:

  1. Make sure to have the Formula Bar visible in Power Query at all times. That way you can see the M code that’s generated by the UI and get you more familiar with it’s syntax.
  2. Formula Language Specification Describes the structure of the language. Make a habit of revisiting it after you’ve practiced for some time - things will start to make more sense…
  3. Formula Reference Bookmark this page. All functions with their specs. Read them, copy the example codes, paste it into the formula bar or advanced editor and study the results :wink:
  4. The Standard Library in Power Query itself which lists all built-in functions:
    #shared keyword can be used to list all the functions available and
    a function name without brackets can be entered to see it’s documentation
  5. Introduction to M an hour long video by Chris Webb, a must see in my opinion!
  6. Practice, practice, practice. Probably the most important thing when learning something new.
    .

Books
For a practical approach: “Collect, Combine And Transform Data Using Power Query In Excel And Power BI” by Gil Raviv

YouTube
Mike excelisfun Girvin Power Query (Get & Transform) Video Playlist
Oz de Solei Get and Transform (Power Query)

Blogs
Chris Webb https://blog.crossjoin.co.uk/
Imke Feldmann https://www.thebiccountant.com/
Ken Puls https://www.excelguru.ca/blog/
Gil Raviv https://datachant.com/

.
If you have something to add, please share it with this community by replying to the tread.
Thank you!

.

Personal note.
Just like in Excel or with DAX there are often multiple ways to solve a problem and the same is true for Power Query. At the moment I like to use the UI as much as possible and only modify the M code when I need to. That way I hardly ever have to write M and that makes it easier to follow along.
But remember, there are alternatives - so don’t forget to explore on your own and report back.
:wink:

5 Likes

Marking the thread as solved.

thanks for great contribution

@Melissa,

Thanks – terrific list. Here are a few more resources that I’ve found very useful:

Blogs
Ben Gribaudo https://bengribaudo.com/

Books
“M Is for Data Monkey” by Ken Puls and Miguel Escobar
“Magic Tricks for Data Wizards” by Ken Puls and Miguel Escobar (free for download here)

  • Brian
1 Like