Formatting Dates with Custom Format Strings in Power Query M

[@BIGorilla]

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]

Got your book last week. Wish there were more real world examples

[@BIGorilla]

@@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]

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 KZbin, together, teaching (M)agic!

[@BIGorilla]

That would be a great collaboration indeed. Who knows one of these days ;-)

[@aniketwanjari2624]

​@@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]

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]

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 🙌

[@gezin_longuevilleosaer4245]

Rick, you bring back the sun on this rainy day. Great demo.

[@BIGorilla]

Ahhh love this. Hope you learned something new!

[@gezin_longuevilleosaer4245]

@@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]

@@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]

For what is essentially a relaxed style the detail is wonderful.

[@shirsN]

Good to see you back on KZbin. You seem to have taken quite a long break 😅

[@BIGorilla]

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]

@@BIGorilla Book that i have already ordered for buying !! tks !!

[@shirsN]

Great, will definitely grab one 😊

[@davelaverie1799]

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]

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]

Amazing!!! For sure I'll use this!

[@williamarthur4801]

Your site is so much easier to navigate and read than a lot of the ms docs.

[@BIGorilla]

Thanks William. Doing what I can ! 🙋‍♂

[@jazzista1967]

HI Rick. Congratulations on your new book. I will check that powerqueryhow portal. Looks really slick.

[@BIGorilla]

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]

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]

@@jazzista1967 it's my pet project. Google doesn' t love it yet (the ranking is bad), but it's definitely worth a read!

[@jazzista1967]

Rick: That site will take out soon! I have looking at it this morning and very resourceful.

[@jazzista1967]

Sorry. it will take off

[@zahoorsarbandi2982]

Thank you for sharing your knowledge and experience. The book would also be very interesting like your video lectures. surely!

[@BIGorilla]

My pleasure!

[@chinsinang8887]

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. :)

[@fungsweewong3774]

Why when I add a month name using this function = Table.AddColumn(#"Added Custom4", "Month Name", each Date.ToText([DateKey],"MMM")), it returns short month name like....Jan, Feb, Mar etc. but for the month of September, it returns Sept iso Sep? Was it suppose to work in this way?

[@stevecloud4soft]

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.