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

Опубликовано: 02 Сентябрь 2026
на канале: Excel Olympics

4,717

107

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