Formatting Dates with Custom Format Strings in Power Query M
ฝัง
- เผยแพร่เมื่อ 16 เม.ย. 2024
- You can format your date with custom format strings. In this video I show you how.
WRITTEN ARTICLE
gorilla.bi/power-query/date-f...
Master Functions and Syntax in M
powerquery.how
ABOUT BI GORILLA
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
Website: gorilla.bi
SUBSCRIBE TO MY CHANNEL
th-cam.com/users/bigorilla?sub_con...
LET'S CONNECT:
Blog: gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#formatstring #date #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/
Got your book last week. Wish there were more real world examples
@@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.
Amazing!!! For sure I'll use this!
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 TH-cam, together, teaching (M)agic!
That would be a great collaboration indeed. Who knows one of these days ;-)
@@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
Rick, you bring back the sun on this rainy day. Great demo.
Ahhh love this. Hope you learned something new!
@@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.
@@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 :)
For what is essentially a relaxed style the detail is wonderful.
Thank you for sharing your knowledge and experience. The book would also be very interesting like your video lectures. surely!
My pleasure!
HI Rick. Congratulations on your new book. I will check that powerqueryhow portal. Looks really slick.
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!
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.
@@jazzista1967 it's my pet project. Google doesn' t love it yet (the ranking is bad), but it's definitely worth a read!
Rick: That site will take out soon! I have looking at it this morning and very resourceful.
Sorry. it will take off
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.
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!
Good to see you back on TH-cam. You seem to have taken quite a long break 😅
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
@@BIGorilla Book that i have already ordered for buying !! tks !!
Great, will definitely grab one 😊
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!
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 🙌
Your site is so much easier to navigate and read than a lot of the ms docs.
Thanks William. Doing what I can ! 🙋♂
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.