Create a Date Table with Power Query - Part 3 of the Date Table Series

In this Video (Part 3 of the Date Table Series), you will learn how to create a Date Table in Power Query With the M language. You will notice that whereas the final Date Table is "created" by M language, you will be able to create it all via the GUI and existing commands. This tutorial was made using Excel 365. Keep in mind that for Excel 2010 and 2013 Power Query is a separate AddInn you have to install. Links to other parts of the Date Table Series: Part 1: What is a Date (Calendar) Table and how to create one in Excel: https://bit.ly/2TTuABk Part 2: Create a Date Table in Power Pivot or Power BI: https://bit.ly/3ioXpPB Part 3: Create a Date Table with Power Query in Excel or Power BI: this video Part 4: Extending the Date Table - Why you NEED to do it: https://bit.ly/2WRy20p Part 5: Extending the Date Table with DAX in Power Pivot or Power BI: https://bit.ly/3CsQm0q Part 6: Extending the Date Table with Power Query in Excel or Power BI: https://bit.ly/3hGQKj3 Chapters: 0:00​ Excel Olympics Animation 0:08 Introduction to the Video 1:20 Introduction to the Data 2:30 Creating a Date Table with Power Query 13:20 Spoilers for next videos 13:36 Outro Gear Used: US Links Camera: Canon EOS R6 - https://amzn.to/3e9zxML Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK Lights: Elgato Key Light - https://amzn.to/3rurte7 EU Links Camera: Canon EOS R6 - https://amzn.to/3tubwGy Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0 Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP Laptop: Dell XPS 15 - https://amzn.to/3effMmT Lights: Elgato Key Light - https://amzn.to/3vcs6v9 Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y Recorded With: Camtasia - https://www.techsmith.com/video-edito... Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK Disclaimer: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support! #Excel #ExcelOlympics #gasperkamensek #PowerQuery #DataModeling #PowerBI