If you want to Master the M language, you can get 'The Definitive Guide to Power Query here: geni.us/ODZl8. And for more info on the Date.ToText function, check out: powerquery.how/date-totext/
@txreal2
5 ай бұрын
Got your book last week. Wish there were more real world examples
@BIGorilla
5 ай бұрын
@@txreal2glad to hear you got the book. I’m surprised about your other comment. The book is full of real world examples, chapter over chapter: - From ascribing data types, - Breaking up your code using variables - what the each construct is for - building a custom connector - how you can use structured values to perform operations on multiple values - building your own custom functions and applying it in real scenarios that are actually common - learning iteration for replacing multiple values - calling an api repeatedly - working with scope - cleaning junk rows from datasets You get the idea. The book has countless examples that are actually used in real world scenarios. You’ll also find projects in the ‘Putting it all together sections’. I’m not sure why you would say otherwise.
@raimundojs9547
6 ай бұрын
It is indeed a huge privilege to be able to watch your lessons. I intend to getting your book as soon as I can. I would love to see you and Melissa de Korte here on KZitem, together, teaching (M)agic!
@BIGorilla
6 ай бұрын
That would be a great collaboration indeed. Who knows one of these days ;-)
@aniketwanjari2624
5 ай бұрын
@@BIGorillaboss can u help me in one thing.. Suppose open time : 12-12-2024 03:00:00 and closed time 14-12-2024 03:00:00 difference: 48:00:00 So I want difference in hh:mm:ss and I will need to show in power query and then visualisation too. Can u please help
@CAKimberlyLewis
6 ай бұрын
I'm so happy to see you back! While you were creating what I am sure is going to be an amazing book, your previous content helped me through so many scenarios. I lost hope on several of them, but then you had an answer! Looking forward to the book! Thank you for everything!
@BIGorilla
6 ай бұрын
Happy to be back to Kimberly. Thanks for such a kind message. I'll be releasing more fun stuff coming weeks, keep an eye out. I think you'lll like it 🙌
@williamarthur4801
6 ай бұрын
Your site is so much easier to navigate and read than a lot of the ms docs.
@BIGorilla
6 ай бұрын
Thanks William. Doing what I can ! 🙋♂
@zahoorsarbandi2982
5 ай бұрын
Thank you for sharing your knowledge and experience. The book would also be very interesting like your video lectures. surely!
@BIGorilla
5 ай бұрын
My pleasure!
@gezin_longuevilleosaer4245
6 ай бұрын
Rick, you bring back the sun on this rainy day. Great demo.
@BIGorilla
6 ай бұрын
Ahhh love this. Hope you learned something new!
@gezin_longuevilleosaer4245
6 ай бұрын
@@BIGorilla Yes Rick, I always do. As now I'm reading your book, chapter 5, ... not always easy to understand but I take it slowly and with patience. I am sure it will boost my M-skills to a next level. Looking forward to your next demo's. Fijne dag nog & groetjes Stéphane Longueville.
@BIGorilla
6 ай бұрын
@@gezin_longuevilleosaer4245 I feel you. Especially since I wrote that chapter. It was probably the hardest one to write from the entire book. I will want to hear your thoughts :)
@williamarthur4801
6 ай бұрын
For what is essentially a relaxed style the detail is wonderful.
@davelaverie1799
6 ай бұрын
I bought your book ... AMAZING!!! I covers more than I could hope for. And powerquery.how delves deep into the specifics of Functions (and their options), Enumerations, Constants and more. You just keep on giving to the community. THANK YOU.
@BIGorilla
6 ай бұрын
I hope more people find their way there. It doesn't yet show up in google result, but it's worth your while. I promise!
@scramiro1
5 ай бұрын
Amazing!!! For sure I'll use this!
@shirsN
6 ай бұрын
Good to see you back on KZitem. You seem to have taken quite a long break 😅
@BIGorilla
6 ай бұрын
Thanks for the warm welcome back. And you're absolutely right. In the last year I've launched the website powerquery.how/ and wrote over 250 articles. At the same time, Melissa de Korte, Greg Deckler and I wrote the 'Definitive Guide to Power Query M (you can get a copy here: amzn.to/3xurWW0) Both took quite a bit of my time. But I do intend to release videos again. Hope to see you back on the channel later :) Rick
@ginesc
6 ай бұрын
@@BIGorilla Book that i have already ordered for buying !! tks !!
@shirsN
6 ай бұрын
Great, will definitely grab one 😊
@jazzista1967
6 ай бұрын
HI Rick. Congratulations on your new book. I will check that powerqueryhow portal. Looks really slick.
@BIGorilla
6 ай бұрын
I'm confident you'll find it refreshing. Better code formatting, interlinking to articles and examples. Nice to hear from you jazzista. Been a while!
@jazzista1967
6 ай бұрын
Rick. I just looked into the site: Man..Its your site. I did not know that! I just placed the link of your site as a favorite in my laptop. I really love it... I will check it out some more at the office later this morning. I will be buying your book but looks scary thick.
@BIGorilla
6 ай бұрын
@@jazzista1967 it's my pet project. Google doesn' t love it yet (the ranking is bad), but it's definitely worth a read!
@jazzista1967
6 ай бұрын
Rick: That site will take out soon! I have looking at it this morning and very resourceful.
@jazzista1967
6 ай бұрын
Sorry. it will take off
@chinsinang8887
2 ай бұрын
Hi, if the data imported is in M/DD/YYYY (US datetime) format, am I able to change it into DD/MM/YYYY (Singapore datetime) format? Thank you. Hope to learn from you. :)
@stevecloud4soft
5 ай бұрын
I have following rows in a column. orderblock_02052024.csv orderblock_03052024.csv To extract date from above rows into new a column i have used following syntex. which gives 02052024 03052024 output values. Table.AddColumn(#"Renamed Columns", "DATE", each Text.BetweenDelimiters([source],"_",".",{0,RelativePosition.FromEnd},{0,RelativePosition.FromStart})) when I format above output values with Date.From/Date.FromText it is giving an error of "We couldn't parse the input provided as a Date value.". May i know the solution for above.
Пікірлер: 34