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!
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.
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
Rick, that is thrilling news! I don't even need to finish watching this video to decide to buy it. Your previous TH-cam 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
Appreciate you GosCee. Really appreciate your trust in our work. I also hope to shoot out some more videos the coming time. It's been a long long time. And it's such a great way of providing content. Stay tuned for more :) Rick
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!
I think you'll love the data types chapter in our new book. Honestly, when I started writing it I thought it was going to be a tough but reasonable chapter. It ended up being the hardest one of all. If you happen to get the book, do drop me a note with your thoughts on it!
I think you'll love the data types chapter in our new book. Honestly, when I started writing it I thought it was going to be a tough but reasonable chapter. It ended up being the hardest one of all. If you happen to get the book, do drop me a note with your thoughts on it!
I believe with each printed version, you can request a pdf with packt for free. If you only want pdf, you can go here: www.packtpub.com/product/the-definitive-guide-to-power-query-m/9781835089729
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!
Hey Erik, That's a good question! There's some great M books out there. M is for data monkey (and the revised version of it), then there's Collect Combine and Transform by Gil Raviv. And both books do well at explaining how to solve practical problems by using the User interface. Gil Raviv even touches some custom M coding for creating your own functions. Yet this book really focuses on the M language itself. The fundamentals of how it works, but also characteristics of data types, values. How you can work with structured values to improve your work flow, create your custom functions, built a connector. I'd say this book teaches you M to solve you solutions, whereas the other ones focus on mostly the UI. While they both have their place, this one gives you the skills to understand the coding language behind all the buttons.
Super! Ik denk echt dat er voor veel mensen een wereld open kan gaan qua M taal. En de talloze mogelijkheden die er zijn. Bedankt voor de aanbevelingen :)!
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
Hey Geert - yes absolutely. I believe the PDF is available through Packt: www.packtpub.com/product/the-definitive-guide-to-power-query-m/9781835089729 They also provide a yearly subscription, just in case you like reading a lot of different technical books. Hope that helps, Rick
@@BIGorilla Bedankt Rick, ik heb de PDF meteen gekocht! Ik ben benieuwd naar dit uitgebreide naslagwerk! 🙂 Het downloaden van de oefenbestanden is een beetje een moeizaam proces - file per file downloaden, en .csv wordt automatisch .txt. (...) Kan dit wat gestroomlijnd worden (bv. een ZIP-file per hoofdstuk)?
@@GeertDelmulle ik moet bekennen zelf niet zo handig te zijn met Github. Maar Greg Deckler stuurt mij net door dat je de bestanden in een keer kunt downloaden als zip. Dan behoudt je ook het CSV formaat, in plaats van .txt. Om dat te doen: 1. Je kunt navigeren naar github.com/PacktPublishing/The-Definitive-Guide-to-Power-Query-M-/ 2. Bovenaan de pagina staat een groene knop met "" 3. Als je daar op klikt staat er "Download Zip" Dan heb je de bestanden van alle hoofdstukken in een keer. Help dat? Groet, Rick
You already got it, I'm glad to hear that ! 🙌. I hope you're going to pick up some cool stuff! We covered a lot of ground, and there's something in there for everyone. The question just remains, where to start ;-) Hope the walk through the table of contents helped. I appreciate your support Kebincui !
Agree. And at the same time, a lot of people have never seen it before. Especially excel users. There’s a huge market for this still to create awareness for!
@@BIGorilla Agree. This book won’t be an entry level for people I think - looking at its contents and structure. I work at a large company (over 11.000 employees) and ofc in D&A roles people know M, but often not well enough (eg Me). The real market expansion is at the ones u just mentioned: good old Excel users performing daunting transformations with IF statements, clicks and all kinds of “crap” to be honest. I still havent found a proper way to let people feel the power of M/PQ. Using PBi reports sometimes works, however they dont care about the back-end so to speak
Hey Luis - You might be able to find some amazon stores that discount the book. For instance, the Dutch store offers the book now with 63% discount for the paperback version: www.amazon.nl/Definitive-Guide-Power-Query-Transformation/dp/1835089720/ref=zg_bs_g_16437535031_d_sccl_1/262-4382161-2742433?psc=1 If you'd find one that does that with the kindle version, you're all set!
@@mrbartuss1Show some respect, man! These people have worked long and hard on this comprehensive book - they deserve some appreciation for their hard labour.
Hi Rick, congrats for the book. This was the missing knowledge in what regards to the M language. We definitely needed a guide to M. Indeed, you were missed. Just curious though, do you cover in your book the trick to call your M steps from a file saved elsewhere for example?!
The book is available at: geni.us/ODZl8. So glad the book can now help others master M. Thank you all for your support, much appreciated 🙌🙌
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!
Hey George, you're so welcome. You even went out of your way to leave a comment. Many thanks!
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.
My man! I hope you're gonna like it!
ordered this instant classic yesterday. thanks!
❤❤ appreciate that. I’m sure you’re gonna find tons of gems useful for your day to day. Thanks for the support Markus!
I just ordered the book. I hope it has a link to sample files.
Hey Rick,
Are you thinking in launch a M course? That would be great.
Great book!
Yes I’m thinking of that too! I hope to work on that in H2 of this year 😁
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.
You rock!
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
Rick, that is thrilling news! I don't even need to finish watching this video to decide to buy it. Your previous TH-cam 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
Appreciate you GosCee. Really appreciate your trust in our work.
I also hope to shoot out some more videos the coming time. It's been a long long time. And it's such a great way of providing content. Stay tuned for more :)
Rick
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!
I think you'll love the data types chapter in our new book. Honestly, when I started writing it I thought it was going to be a tough but reasonable chapter. It ended up being the hardest one of all. If you happen to get the book, do drop me a note with your thoughts on it!
I think you'll love the data types chapter in our new book. Honestly, when I started writing it I thought it was going to be a tough but reasonable chapter. It ended up being the hardest one of all. If you happen to get the book, do drop me a note with your thoughts on it!
This is high-quality work. Look forward to buying a copy!
Thank you! Go for it ;) I’m sure you’ll like it!
Hi Rick, How can i get PDF version, is it available for purchasing.
I believe with each printed version, you can request a pdf with packt for free.
If you only want pdf, you can go here: www.packtpub.com/product/the-definitive-guide-to-power-query-m/9781835089729
Awesome! I have learned SO much after subscribing to Packt. Definitely worth the subscription! Will be downloading this asap !
Welcome aboard!
I have your book. It is indeed everything you say. I am reading it cover to cover.
I am very happy to have it! ❤
Wow, thank you!
Hi Rick, I have hearded about you recently. In your book, do you explain the advance M code?
Thank you…
Absolutely. From fundamentals to more advanced concepts. There’s something in there if you want to master the M language. 😊
Congrats Rick!
❤ thank you!
Eagerly awaiting to buy this book. Thanks for all the effort.
Hope you enjoy it!
Ordered the book. Good work
Thank you!
I have just purchased your book. Thanks for the great ideas! 💡
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!
Hey Erik,
That's a good question! There's some great M books out there. M is for data monkey (and the revised version of it), then there's Collect Combine and Transform by Gil Raviv.
And both books do well at explaining how to solve practical problems by using the User interface. Gil Raviv even touches some custom M coding for creating your own functions.
Yet this book really focuses on the M language itself. The fundamentals of how it works, but also characteristics of data types, values. How you can work with structured values to improve your work flow, create your custom functions, built a connector.
I'd say this book teaches you M to solve you solutions, whereas the other ones focus on mostly the UI. While they both have their place, this one gives you the skills to understand the coding language behind all the buttons.
@@BIGorilla That's excellent and exactly what i was looking for. Look forward going through it !
@@eriknegron1047 Fantastic, enjoy the read!
Just bought it...looking forward to reading this amazing book. 😀
enjoy! I'm confident you'll pick up some nice tips and tricks!
Rick, ik heb je boek ondertussen sterk aanbevolen aan mijn collega-dataspecialisten op het werk.
Super! Ik denk echt dat er voor veel mensen een wereld open kan gaan qua M taal. En de talloze mogelijkheden die er zijn. Bedankt voor de aanbevelingen :)!
Purchased !!
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
Glad it was helpful! Hope you like the book🙏
Hi Rick, welcome back. We miss you
I've missed you too. Back in action now :)
Trusting your efforts on bringing this book out successfully. Thank you very much.. Bought it 😁
Hope you enjoy it!
Can I buy it in PDF so I can look things up in the book?
Hey Geert - yes absolutely. I believe the PDF is available through Packt: www.packtpub.com/product/the-definitive-guide-to-power-query-m/9781835089729
They also provide a yearly subscription, just in case you like reading a lot of different technical books. Hope that helps, Rick
@@BIGorilla Bedankt Rick, ik heb de PDF meteen gekocht! Ik ben benieuwd naar dit uitgebreide naslagwerk! 🙂
Het downloaden van de oefenbestanden is een beetje een moeizaam proces - file per file downloaden, en .csv wordt automatisch .txt. (...)
Kan dit wat gestroomlijnd worden (bv. een ZIP-file per hoofdstuk)?
@@GeertDelmulle ik moet bekennen zelf niet zo handig te zijn met Github. Maar Greg Deckler stuurt mij net door dat je de bestanden in een keer kunt downloaden als zip. Dan behoudt je ook het CSV formaat, in plaats van .txt. Om dat te doen:
1. Je kunt navigeren naar github.com/PacktPublishing/The-Definitive-Guide-to-Power-Query-M-/
2. Bovenaan de pagina staat een groene knop met ""
3. Als je daar op klikt staat er "Download Zip"
Dan heb je de bestanden van alle hoofdstukken in een keer. Help dat?
Groet, Rick
Already bought it ❤👍
You already got it, I'm glad to hear that ! 🙌. I hope you're going to pick up some cool stuff! We covered a lot of ground, and there's something in there for everyone. The question just remains, where to start ;-)
Hope the walk through the table of contents helped. I appreciate your support Kebincui !
M is highly underrated, yet powerful. Cheers
Agree. And at the same time, a lot of people have never seen it before. Especially excel users. There’s a huge market for this still to create awareness for!
@@BIGorilla Agree. This book won’t be an entry level for people I think - looking at its contents and structure. I work at a large company (over 11.000 employees) and ofc in D&A roles people know M, but often not well enough (eg Me). The real market expansion is at the ones u just mentioned: good old Excel users performing daunting transformations with IF statements, clicks and all kinds of “crap” to be honest. I still havent found a proper way to let people feel the power of M/PQ. Using PBi reports sometimes works, however they dont care about the back-end so to speak
Bonjour à vous !
Une version française du guide serait grandement appréciée...🙏
At the moment, no. Who knows, maybe in the future!
Own it and love it
Great! Now give us a Gorilla discount, I guy from Brazil wants to get it😅
Hey Luis - You might be able to find some amazon stores that discount the book. For instance, the Dutch store offers the book now with 63% discount for the paperback version: www.amazon.nl/Definitive-Guide-Power-Query-Transformation/dp/1835089720/ref=zg_bs_g_16437535031_d_sccl_1/262-4382161-2742433?psc=1
If you'd find one that does that with the kindle version, you're all set!
Awesome!!! it's going to be like to have a piece of your brain printend in my hands.
Hope you like it. And I agree. It sure feels like a piece of my brain is in it. It’s still recovering from the writings 🤯 😋
Good to know you still remember your YT password
I know right. The password just popped up in my mind today. And I got lucky it worked. Hope to be here more now :)
@@BIGorilla We hope so too!
@@mrbartuss1Show some respect, man!
These people have worked long and hard on this comprehensive book - they deserve some appreciation for their hard labour.
@@GeertDelmulle Respect is what I meant. I really hope there will be more videos from him
💯👍
We are all waiting for Microsoft to improve the M editor. Asking Find and alike functions is too much? A debugger I bet is just out of discussion...
That would be so nice. Hopefully its coming later!
Hi Rick, congrats for the book. This was the missing knowledge in what regards to the M language. We definitely needed a guide to M.
Indeed, you were missed.
Just curious though, do you cover in your book the trick to call your M steps from a file saved elsewhere for example?!
We don't cover that in the book since it's a method I don't recommend in general. Ofcourse feel free to use it!
Good job!
Thank you!