Create a Calendar Table based on Start and End Date Inputs
If you're into building data models and your tables include dates, a good thing to have is a separate calendar table. You may want to create a calendar table that has the date, month name, year day name, etc. This gives you ways to slice and dice the data for further analysis and also a way to uniformly reference your other tables to one calendar table. It's fairly easy to create a list of dates in Excel by having a start date and incrementing by one day, but that is static. You'll always need to update it when new data comes in. The preferable way to do this is to automate it and that's when Power Query comes into play.
0:00 Intro
0:38 Fill Series Command
2:27 Using Power Query
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF File to Excel
~-~~-~~~-~~-~