4 Ways to Create Date Column for a Calendar in Power Query
ฝัง
- เผยแพร่เมื่อ 29 ก.ค. 2024
- This videos shows 4 ways to create date series out of thin air in Power Query. Any of these works as robust first step for a date table.
WRITTEN BLOGPOST:
gorilla.bi/power-query/date-t...
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.
SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: paypal.me/rickmaurinus.
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!
00:00 Introduction
00:50 Using Autofill within List
03:49 Function: List.Numbers
07:11 Function: List.Dates
09:15 Function: List.Generate
#calendar #dates #powerquery
![[TH] 2024 PMWC x EWC Main Tournament Day 2 | PUBG MOBILE WORLD CUP x ESPORTS WORLD CUP](http://i.ytimg.com/vi/TgEFw285vXA/mqdefault.jpg)
![บุษบา - เมนทอล [Official MV]](http://i.ytimg.com/vi/IGnWPokSEis/mqdefault.jpg)
Quality Content. Clear , Concise and Comprehensive.
Keep it coming....
Awesome, I'm getting pro each day in Power Query by watching your videos and of course because of you!, thank you so much, greetings from dominican Republic.🎉
This guy. What a hero
And what would I be without supporters. You are the real hero Max. Amen 🙏
Thank you so much for this video! You're the best!
Awesome Date info. Thanks a lot for sharing. 5 Stars!
Awesome!
The content and quality of all your videos is second to none!
I look forward to more of your videos. Great lessons. Thank you! 👏
Thanks Mariusz, happy to help! I find the more we share, the more we all learn. And there’s a lot of areas that can use more content. Have you ever considered making content?
This was helpful. Thank you
Good stuff! Thank you!!!
This is my favorite Power Query content channel. Please keep sharing these awesome contents
That’s very kind, thank you🙌
Your content is amazing! Thank you so much for sharing! New subscriber.
🙏 Thanks Luis, it's so nice to hear you like the content. Thanks for leaving a comment. There's more coming soon!!
Great tutorials, keep more coming Rick
Thanks aytunch. 🙏 keep monitoring, more coming next week!
thank you for sharing!!!!!!!!!!!!!!!!!!! waiting for part 2 :)
Coming next week Dec 22nd!
This is great context, with simple explanations.
Is it possible to link the value of the variables to a lower and upper value of another table containing transactional data?
Hi! Very good video!
What if I want to create a column in an excising table? referencing the column "source" so it will take the date from de SP
That's awesome. But how to generate dates between 2 date intervals of same date column? i have a date column 11/11/2021 and in second row its 1/3/2022 how to fill the dates between these 2 dates?
Really good, it must be it's my third time of watching, mainly for the list.generate. If I had a question, it would be regarding the use of the underscore , and when and why it is needed after 'each' but not always.
Perhaps a future video, I don't think it's been done.
The underscore is short for a function:
The m language has some short syntaxes that do the same. They allow you to perform an operation on each underlying value. Equivalent are :
Each _
Each () => _
Each (x)=> x
The version in the video is a short way to write it. To make life easier :)
@@BIGorilla Thanks, I did quite bit of experimentation after watching your 'generate' video, using each _ ,
List.Generate( () => 1,
(_)=> _ < 7,
(_)=> _ + 1 )
List.Generate( () => 1,
(A)=> A < 7 ,
(A)=> A + 1 )
What I found interesting was that the 'initial function could not be named,
I first tried to use the _ or 'A' within that as well.
Richard.
Hi!
I have a doubt.
Instead of using a parameter, how do I reference the StartDate and the EndDate that is already in a columm inside a table?
Would there be multiple dates? And do you want multiple calendars?