The Definitive Guide to Power Query M - What to expect?

I'm happy to announce our new book: 'The Definitive Guide to Power Query (M). The book aims to teach users the M language, so they can solve almost 100% of their data transformation challenges. In this video, I walk through the table of contents and provide context on what the book teaches.

WRITTEN ARTICLE:

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#M #powerquery #bigorilla

[GeorgeKlucsarits]

Hi Rick, I received the book a couple of days ago and it's an outstanding reference that I recommend to anyone looking to improve their Power Query skills. You, Gregory and Melissa have done a great job in creating a resource for those who were looking for that "next level" when it comes to PQ.
Right now I'm doing a deep dive into Chapter 3: Accessing and Combining Data. It's great to be able to fully understand what PQ is doing and how I can improve and optimize a task I do almost daily. So far, just about every chapter has revealed some tip or trick or explanation that will improve my workflow and make my job easier.
I've taken advantage of your YT and blog content for some time, and Melissa's famous date table has been my go-to solution for a long time. Glad to be able to support your efforts in a small way by buying this book.
Thanks!

[juansebastianquinteroboter]

It nice to see you back, I bought the book and I am hyped to read it. I am hopeful that you have a successful book publication.

[claygli]

I have your book. It is indeed everything you say. I am reading it cover to cover.

I am very happy to have it! ❤

[markusleucht]

ordered this instant classic yesterday. thanks!

[whizzohk]

Another customer! Book bought. Thanks Rick and team for identifying a gap in the market when it comes to focussing on M itself, rather than just the M generated by the UI.

[adwaitetiwarycfa]

This is high-quality work. Look forward to buying a copy!

[melann]

Awesome! I have learned SO much after subscribing to Packt. Definitely worth the subscription! Will be downloading this asap !

[GosCee]

Rick, that is thrilling news! I don't even need to finish watching this video to decide to buy it. Your previous YouTube videos give me enough reason to make this book a must-have. I am looking forward to using it. Thank you very much for all your help with Power Query. Cheers

[Gosiapon]

I have just purchased your book. Thanks for the great ideas! 💡

[McIlravyInc]

Data types are the main cause of many of my unexpected results in PQ, especially when doing replace or other matching to lookup/merge etc. So they are VERY important to me!

[Franklinvaz]

Trusting your efforts on bringing this book out successfully. Thank you very much.. Bought it 😁

[themolestones]

Just bought it...looking forward to reading this amazing book. 😀

[mcwahaab]

Eagerly awaiting to buy this book. Thanks for all the effort.

[marcusdrees]

Hi Rick, I have just ordered it as well and I am sure it will be of great help on my personal M-Journey. Thank you for your videos you have done for the community.

Marcus

[cooolbreeze]

I think there is an error in Chapter 3. On Page 59, in the section about Folders, 2nd paragraph, describes how Folder.Contents and File.Contents works. I think you meant to describe how Folder.Contents and Folder.Files work? Also, what is said about Folder.Contents is confusing. It implies that the function will delve into each folder within the path. But this function's scope is only the folder that's fed to it

[monicacisneros]

I just ordered the book. I hope it has a link to sample files.

[eriknegron]

Thanks for the explanation.
Was debating about getting it, have it in my wishlst, but was not sure how it compared to the likes of M is for Data Monkey which i already own. This will be a nice addition to my collection.
Congrats on the publication!

[rodrigochavez]

Hey Rick,
Are you thinking in launch a M course? That would be great.
Great book!

[gezin_longuevilleosaer]

Rick, ik heb je boek ondertussen sterk aanbevolen aan mijn collega-dataspecialisten op het werk.

[aartdevletter]

M is highly underrated, yet powerful. Cheers