Miguel Escobar Published August 14, 2021

New book is out!

Power BI

Ken and I have been delaying the release date for the second edition of our book ‘M is for Data Monkey’, but not anymore! 🙂

The book is finally ready and it was silently released a couple of weeks ago through various digital marketplaces.

The physical copies will be available on November 1, 2021 and you can pre-order your copy from Amazon or your favorite book store.

Over the past few weeks I’ve been getting quite a few questions around the new book so I thought that I’d create a short FAQ to summarize them all.

Book’s FAQ

  • What took you guys so long to finish the book?
    • The main reasons where time commitments, constant changes in the Power Query UI that prevented us from making commitments to certain features, and, quite personally, a mind blockage when trying to create new and improved content.

      At the end of the day, Ken and I managed to overcome all obstacles and finished something that we’re both extremely proud of and we hope you (the reader) find it valuable.
  • I already bought the first edition, I don’t need this new book, right?
    • This new book is not really an update of the first book, but more of a full overhaul on every single chapter except the first one where we (Ken and I) tell our stories that brought us to writing this book together.

      While the first edition does give you a great foundation to understand Power Query and the M language, think about this book as the one that holds the content that is most up-to-date, refined and efficient in terms of trying to understanding Power Query and the M language. All of the topics that were covered in the first book are also covered in this new one, but we believe that we did a far better and more accurate job this time. Not to mention that we also cover some new content that is unique to this book and not available anywhere else.
  • What’s something unique that was covered in this book that is not in the first edition?
    • You could say that almost all the content is new and unique. You’ll immediately see the difference in the size of the book since this new book has over 30% more content than the previous one. That’s because we re-wrote almost every single line to reflect the current and future states of Power Query. However, speaking from more of a conceptual standpoint, every single concept that you get from the first edition is also in the new book.

      Furthermore, the new book covers some new concepts that are pretty unique and were not even available when we wrote the first edition of the book. Some of those are:
      • New and more accurate content on query evaluation (throughout the whole book)
      • Completely revamped content on Power Query values and the M language for everyone that wants to get to the next level in learning the M language. (Chapters 15 and 16)
      • New content on Parameters and creating custom functions (Chapter 17)
      • New content on using column from examples as well as other “by example” features (Various Chapters)
      • New diagrams and more visuals (throughout the whole book)
      • Full-blown chapter on query optimization and showcasing the main use case for the Buffer functions (Chapter 19)

If there’s anything else that you’d like to see in the FAQ, leave it in the comments below!

Power BI
Notify of
7 Comentario
Newest Most Voted
Inline Feedbacks
View all comments

I am eager for one.
As of 8/19/2021 21:30 JST, amazon.com says this book is “Currently unavailable”.

Carlos B. Fontiveros

You mentioned it was released early on various digital marketplaces… which ones?

Sue Walters

I just purchased the first book and looks like it’s going to be very helpful! I have a question that I have been searching the web for for awhile. I’m hoping you can help.
I was hoping to remove a list of about 170 customers from my query. I have their emails and that’s how I need to eliminate them. I know I can filter and copy and paste each and every email in to text does not contain but is there a way to copy and paste the whole list into the advanced editor but not having to manually type if all the and not text contains, etc around each and every email address?
Thanks in advance!

Ahmed M Ibrahim

How to get the new book Miguel ?