Extending the Date Table for your data Model - Part 6 of the Date Table Series
In this video, You will learn how to Extend the Date Table by using M language within Power Query either in Excel or in Power BI. All the crucial columns we defined in Part 4 of the series will now come to life in Excels Power Query or Power BI.
This tutorial was made using Excel 365. All the concepts and formulas can be Applied / Calculated in any Version of Excel that supports Power Query (so 2010 or later).
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:https://bit.ly/3xuxDh8
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: This Video
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction to the Video
1:20 Adding the YearMonth Column
3:56 Creating the YearMonth Index
4:58 Running / Rolling 13 Flag Column
10:00 Current Month
11:24 Food For Thought
13:40 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-editor.html
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
Видео Extending the Date Table for your data Model - Part 6 of the Date Table Series канала Excel Olympics
This tutorial was made using Excel 365. All the concepts and formulas can be Applied / Calculated in any Version of Excel that supports Power Query (so 2010 or later).
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:https://bit.ly/3xuxDh8
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: This Video
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction to the Video
1:20 Adding the YearMonth Column
3:56 Creating the YearMonth Index
4:58 Running / Rolling 13 Flag Column
10:00 Current Month
11:24 Food For Thought
13:40 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-editor.html
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
Видео Extending the Date Table for your data Model - Part 6 of the Date Table Series канала Excel Olympics
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Excel Olympics Channel Trailer](https://i.ytimg.com/vi/jjZl6LaKtek/default.jpg)
![Interview with George Mount - The Author of Advancing into Analytics](https://i.ytimg.com/vi/9dSZgRR9obc/default.jpg)
![The New Filter Function in Excel](https://i.ytimg.com/vi/_UBvt-F5VII/default.jpg)
![Biggest Boost to my Power BI Game in 2021](https://i.ytimg.com/vi/IRUwJnk6gD8/default.jpg)
![R Academy - ggplot2 basics in 15 minutes](https://i.ytimg.com/vi/Tim5Tm6S7kQ/default.jpg)
![Create a Date Table with Power Query - Part 3 of the Date Table Series](https://i.ytimg.com/vi/8COCMiH60jw/default.jpg)
![Create an Excel DropDown List in 0.02 Seconds - Alt & DownArrow](https://i.ytimg.com/vi/cA7gJf7HGOQ/default.jpg)
![Biggest Boost to My Excel Game in 2021](https://i.ytimg.com/vi/Hty-923bQAc/default.jpg)
![5 Excel Shortcuts using the ALT key](https://i.ytimg.com/vi/oiu4y-jX_1k/default.jpg)
![Extending the Date Table for your Data Model - Part 5 of the Date Table Series](https://i.ytimg.com/vi/uSkcjVu_Tug/default.jpg)
![Consolidate Data from All Excel Worksheets in Multiple Excel Workbooks](https://i.ytimg.com/vi/Iz40zAvyOBI/default.jpg)
![Min Max Chart in Excel](https://i.ytimg.com/vi/vyAaFDYViRM/default.jpg)
![RANDARRAY Function in Excel](https://i.ytimg.com/vi/E9tnLCzXL88/default.jpg)
![7 Tips and Tricks in Excel - Level 300 (Expert Level)](https://i.ytimg.com/vi/-LZbPNoWd-o/default.jpg)
![Sequence function with a break in Excel - Your Questions Answered Series](https://i.ytimg.com/vi/-nZYzoZ0w_s/default.jpg)
![Interview with Oz du Soleil, author of Guerrilla Data Analysis Using Microsoft Excel](https://i.ytimg.com/vi/zUzsos0IyZA/default.jpg)
![Ctrl and Enter in Excel - YOU NEED TO KNOW THIS! - Hit the ground running in Excel Series - Part 1](https://i.ytimg.com/vi/Gm-dOxuYk64/default.jpg)
![Why each and every Excel user should use Power Query](https://i.ytimg.com/vi/hdyjy3GjhGQ/default.jpg)
![Filtering a Table to a Dynamic List of Values using Power Query and Power BI](https://i.ytimg.com/vi/irO92dlVMVg/default.jpg)
![7 Tips and Tricks in Excel - Level 200 (Intermediate Level)](https://i.ytimg.com/vi/zz7BvQ53vGM/default.jpg)