www.youtube.com Open in urlscan Pro
2a00:1450:4001:80e::200e  Public Scan

Form analysis
1 forms found in the DOM

/results

<form id="search-form" action="/results" class="style-scope ytd-searchbox">
  <div id="container" class="style-scope ytd-searchbox">
    <yt-icon id="search-icon" class="style-scope ytd-searchbox"><!--css-build:shady--><!--css-build:shady--><yt-icon-shape class="style-scope yt-icon"><icon-shape class="yt-spec-icon-shape">
          <div style="width: 100%; height: 100%; fill: currentcolor;"><svg xmlns="http://www.w3.org/2000/svg" enable-background="new 0 0 24 24" height="24" viewBox="0 0 24 24" width="24" focusable="false"
              style="pointer-events: none; display: block; width: 100%; height: 100%;">
              <path d="m20.87 20.17-5.59-5.59C16.35 13.35 17 11.75 17 10c0-3.87-3.13-7-7-7s-7 3.13-7 7 3.13 7 7 7c1.75 0 3.35-.65 4.58-1.71l5.59 5.59.7-.71zM10 16c-3.31 0-6-2.69-6-6s2.69-6 6-6 6 2.69 6 6-2.69 6-6 6z"></path>
            </svg></div>
        </icon-shape></yt-icon-shape></yt-icon>
    <div id="search-input" class="ytd-searchbox-spt" slot="search-input"><input id="search" autocapitalize="none" autocomplete="off" autocorrect="off" name="search_query" tabindex="0" type="text" spellcheck="false" placeholder="Search"
        aria-label="Search"></div>
    <div id="search-clear-button" class="style-scope ytd-searchbox" hidden=""><ytd-button-renderer class="style-scope ytd-searchbox" button-renderer="" button-next=""><!--css-build:shady--><yt-button-shape><button
            class="yt-spec-button-shape-next yt-spec-button-shape-next--text yt-spec-button-shape-next--mono yt-spec-button-shape-next--size-m yt-spec-button-shape-next--icon-only-default" aria-label="Clear search query" title="" style="">
            <div class="yt-spec-button-shape-next__icon" aria-hidden="true"><yt-icon style="width: 24px; height: 24px;"><!--css-build:shady--><!--css-build:shady--><yt-icon-shape class="style-scope yt-icon"><icon-shape class="yt-spec-icon-shape">
                    <div style="width: 100%; height: 100%; fill: currentcolor;"><svg xmlns="http://www.w3.org/2000/svg" enable-background="new 0 0 24 24" height="24" viewBox="0 0 24 24" width="24" focusable="false"
                        style="pointer-events: none; display: block; width: 100%; height: 100%;">
                        <path d="m12.71 12 8.15 8.15-.71.71L12 12.71l-8.15 8.15-.71-.71L11.29 12 3.15 3.85l.71-.71L12 11.29l8.15-8.15.71.71L12.71 12z"></path>
                      </svg></div>
                  </icon-shape></yt-icon-shape></yt-icon></div><yt-touch-feedback-shape style="border-radius: inherit;">
              <div class="yt-spec-touch-feedback-shape yt-spec-touch-feedback-shape--touch-response" aria-hidden="true">
                <div class="yt-spec-touch-feedback-shape__stroke" style=""></div>
                <div class="yt-spec-touch-feedback-shape__fill" style=""></div>
              </div>
            </yt-touch-feedback-shape>
          </button></yt-button-shape><tp-yt-paper-tooltip fit-to-visible-bounds="" offset="8" disable-upgrade=""></tp-yt-paper-tooltip></ytd-button-renderer></div>
  </div>
  <div id="search-container" class="ytd-searchbox-spt" slot="search-container"></div>
</form>

Text Content

•


NaN / NaN













Back





GB
Skip navigation

Search
Search



Sign in



GB





Extending the Date Table for your Data Model - Part 4 of the Date Table Series

Search

Watch Later

Share

Copy link

Info

Shopping


Tap to unmute

2x



If playback doesn't begin shortly, try restarting your device.









•
Up next

Live
Upcoming


CancelPlay now


You're signed out
Videos that you watch may be added to the TV's watch history and influence TV
recommendations. To avoid this, cancel and sign in to YouTube on your computer.
CancelConfirm



Excel Olympics

Subscribe

Subscribed
My name is Gašper Kamenšek, and I've been working with and teaching Excel since
Excel XP (the forgotten version :) ) and Power BI since v1. In 2016 I received
the Microsoft MVP award for Excel, and I have been a part of the MVP community
ever since. This channel is my way of giving back. It's all about sharing my
experience and know-how with YOU to help you get better in Excel and Power BI.

What is a Date Table and how to create one in Excel - The Date Table (Calendar)
Series - Part 1
11:09
Time Intelligence in Excel and Power BI
8 videos



Share
Include playlist


An error occurred while retrieving sharing information. Please try again later.



0:00






0:00 / 19:53•Watch full videoLive
•
Excel Olympics Animation

•


Scroll for details




EXTENDING THE DATE TABLE FOR YOUR DATA MODEL - PART 4 OF THE DATE TABLE SERIES

Excel Olympics
Excel Olympics
5.85K subscribers



<__slot-el>
Subscribe



<__slot-el>
Subscribed



48




Share

Download

Download

Save








1.7K views 2 years ago Time Intelligence in Excel and Power BI
1,706 views • 24 Aug 2021 • Time Intelligence in Excel and Power BI

Show less
This video is, without doubt, the most crucial part of the series as I will show
you how to extend the date (calendar) table to get a lot more flexibility in
your Excel and Power BI reports and Dashboards.  …...more
...more
CHAPTERS

VIEW ALL





EXCEL OLYMPICS ANIMATION

EXCEL OLYMPICS ANIMATION

0:00

EXCEL OLYMPICS ANIMATION

0:00




INTRODUCTION TO THE VIDEO

INTRODUCTION TO THE VIDEO

0:08

INTRODUCTION TO THE VIDEO

0:08




THE MOST IMPORTANT COLUMN

THE MOST IMPORTANT COLUMN

0:52

THE MOST IMPORTANT COLUMN

0:52




ROLLING 13 INTRODUCTION

ROLLING 13 INTRODUCTION

5:02

ROLLING 13 INTRODUCTION

5:02




CURRENT MONTH AND CURRENT YEAR IDEA

CURRENT MONTH AND CURRENT YEAR IDEA

12:59

CURRENT MONTH AND CURRENT YEAR IDEA

12:59




SPOILERS OF PART 5 AND PART 6

SPOILERS OF PART 5 AND PART 6

19:30

SPOILERS OF PART 5 AND PART 6

19:30




OUTRO

OUTRO

19:44

OUTRO

19:44




Featured playlist
8 videos

8 videos
Time Intelligence in Excel and Power BI
Excel Olympics

Transcript

Follow along using the transcript.

Show transcript



EXCEL OLYMPICS

5.85K subscribers
Videos

About

Videos


About


Subscribe


LinkedIn


6:46


Sorting months chronologically and not alphabetically in Power Pivot based Pivot
Tables in Excel
by Excel Olympics
Show less







Time Intelligence in Excel and Power BI


EXTENDING THE DATE TABLE FOR YOUR DATA MODEL - PART 4 OF THE DATE TABLE SERIES

1,706 views1.7K views
24 Aug 2021

48




Share

Download

Download

Save














8 COMMENTS

Sort comments
Sort by
Top comments

Newest first






Add a comment…










@VASUDEVAACHARYA

2 years ago

Thank you for extending my knowledge of excel into PowerQuery and Date Tables.
This will help me in the long run.
Show less Read more

1


Like
1


Dislike
❤ by Excel Olympics

Reply





·
1 reply


·
1 reply







@WAYNEEDMONDSON1065

2 years ago

Hi Gasper. Awesome tricks and techniques! Love the Rolling 13 in a visual and
making it dynamic. Thanks for sharing these tips :)) Thumbs up!!
Show less Read more

2


Like
2


Dislike


Reply





·
1 reply


·
1 reply







@GEERTDELMULLE

2 years ago

Hi Gasper, Supercharging the dDate (/dCalendar) table like this is a really cool
trick. Especially if you use PQ-M to construct it. I've (re)constructed one
myself and will add this to my toolbox. Thanks for the insight! Greatly
appreciated.
Show less Read more

2


Like
2


Dislike


Reply





·
1 reply


·
1 reply







@DANJARUPATH

1 year ago

Awesome
Show less Read more

0


Like
0


Dislike


Reply





·
1 reply


·
1 reply






CHAPTERS







EXCEL OLYMPICS ANIMATION

EXCEL OLYMPICS ANIMATION

0:00

EXCEL OLYMPICS ANIMATION

0:00




INTRODUCTION TO THE VIDEO

INTRODUCTION TO THE VIDEO

0:08

INTRODUCTION TO THE VIDEO

0:08




THE MOST IMPORTANT COLUMN

THE MOST IMPORTANT COLUMN

0:52

THE MOST IMPORTANT COLUMN

0:52




ROLLING 13 INTRODUCTION

ROLLING 13 INTRODUCTION

5:02

ROLLING 13 INTRODUCTION

5:02




CURRENT MONTH AND CURRENT YEAR IDEA

CURRENT MONTH AND CURRENT YEAR IDEA

12:59

CURRENT MONTH AND CURRENT YEAR IDEA

12:59




SPOILERS OF PART 5 AND PART 6

SPOILERS OF PART 5 AND PART 6

19:30

SPOILERS OF PART 5 AND PART 6

19:30




OUTRO

OUTRO

19:44

OUTRO

19:44


Sync to video time
Sync to video time




DESCRIPTION






Extending the Date Table for your Data Model - Part 4 of the Date Table Series
48Likes
1,706Views
202124 Aug
This video is, without doubt, the most crucial part of the series as I will show
you how to extend the date (calendar) table to get a lot more flexibility in
your Excel and Power BI reports and Dashboards. This tutorial was made using
Excel 365. All the concepts and formulas can be Applied / Calculated in any
Version of Excel 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: This Video 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 0:52 The most Important Column 5:02
Rolling 13 Introduction 12:59 Current Month and Current Year idea 19:30 Spoilers
of Part 5 and Part 6 19:44 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
Show less Show more
CHAPTERS

VIEW ALL





EXCEL OLYMPICS ANIMATION

EXCEL OLYMPICS ANIMATION

0:00

EXCEL OLYMPICS ANIMATION

0:00




INTRODUCTION TO THE VIDEO

INTRODUCTION TO THE VIDEO

0:08

INTRODUCTION TO THE VIDEO

0:08




THE MOST IMPORTANT COLUMN

THE MOST IMPORTANT COLUMN

0:52

THE MOST IMPORTANT COLUMN

0:52




ROLLING 13 INTRODUCTION

ROLLING 13 INTRODUCTION

5:02

ROLLING 13 INTRODUCTION

5:02




Featured playlist
8 videos

8 videos
Time Intelligence in Excel and Power BI
Excel Olympics

Transcript

Follow along using the transcript.

Show transcript



EXCEL OLYMPICS

5.85K subscribers
Videos

About

Videos


About


Subscribe


LinkedIn


6:46


Sorting months chronologically and not alphabetically in Power Pivot based Pivot
Tables in Excel
by Excel Olympics



COMMENTS 8




Top comments

Newest first







TRANSCRIPT









NaN / NaN









15:38
Now playing




EXTENDING THE DATE TABLE FOR YOUR DATA MODEL - PART 5 OF THE DATE TABLE SERIES

Excel Olympics
Excel Olympics
•
•
952 views 2 years ago







20:07
Now playing




PIVOT TABLE VS A POWER PIVOT BASED PIVOT TABLE

Excel Olympics
Excel Olympics
•
•
23K views 2 years ago







20:06
Now playing




WHAT IS A DATE TABLE / CALENDAR TABLE IN POWER BI / EXCEL

Access Analytic
Access Analytic
•
•
31K views 2 years ago







14:02
Now playing




HOW AND WHERE TO WRITE DAX MEASURES FOR POWER BI AND EXCEL

MyOnlineTrainingHub
MyOnlineTrainingHub

Verified
•
•
72K views 2 years ago







21:26
Now playing




DATE TABLE FOR POWER BI USING POWER QUERY

How to Power BI
How to Power BI

Verified
•
•
114K views 3 years ago







6:15
Now playing




CONVERT DATES TO FISCAL PERIODS IN EXCEL - EASY FORMULA

MyOnlineTrainingHub
MyOnlineTrainingHub

Verified
•
•
68K views 3 years ago







11:09
Now playing




WHAT IS A DATE TABLE AND HOW TO CREATE ONE IN EXCEL - THE DATE TABLE (CALENDAR)
SERIES - PART 1

Excel Olympics
Excel Olympics
•
•
9.8K views 2 years ago







10:18
Now playing




COMBINE FILES FROM A FOLDER WITH POWER QUERY THE RIGHT WAY!

MyOnlineTrainingHub
MyOnlineTrainingHub

Verified
•
•
93K views 9 months ago







13:54
Now playing




PROPERLY HANDLING DATE GROUPING IN EXCEL PIVOT TABLES (CHANGE GROUPING, GET ALL
DATES)

Leila Gharani
Leila Gharani

Verified
•
•
284K views 1 year ago







1:06:42
Now playing




[POWER BI] ADVANCED DAX WITH CALCULATE: THE MOST POWERFUL FUNCTION IN DAX

Xperiun | Data Analytics
Xperiun | Data Analytics
•
•
24K views Streamed 3 years ago







12:48
Now playing




EASILY FIX DATES FORMATTED AS TEXT WITH POWER QUERY

MyOnlineTrainingHub
MyOnlineTrainingHub

Verified
•
•
96K views 3 years ago







30:27
Now playing




7 TIPS AND TRICKS IN EXCEL - LEVEL 300 (EXPERT LEVEL)

Excel Olympics
Excel Olympics
•
•
5.4K views 2 years ago







26:56
Now playing




JOIN TYPES IN POWER QUERY

Excel Olympics
Excel Olympics
•
•
7.2K views 2 years ago







14:26
Now playing




CREATE A DATE TABLE IN POWER PIVOT OR POWER BI - PART 2 OF THE DATE TABLE SERIES

Excel Olympics
Excel Olympics
•
•
5.1K views 2 years ago







14:21
Now playing




MEASURES AND KPIS IN EXCEL. POWER PIVOT FOR BEGINNERS

ITsEasyTraining1st
ITsEasyTraining1st
•
•
25K views 3 years ago







18:31
Now playing




CREATE A DATA MODEL IN EXCEL

ExcelDemy
ExcelDemy
•
•
2.6K views 1 month ago







16:35
Now playing




HOW TO USE MICROSOFT POWER QUERY

Kevin Stratvert
Kevin Stratvert

Verified
•
•
1.6M views 3 years ago







2:11:02
Now playing




TOP 10 ADVANCED EXCEL TRICKS FOR DATA ANALYSIS - FREE MASTERCLASS WITH SAMPLE
FILES

Chandoo
Chandoo

Verified
•
•
293K views Streamed 1 year ago







14:12
Now playing




EXTENDING THE DATE TABLE FOR YOUR DATA MODEL - PART 6 OF THE DATE TABLE SERIES

Excel Olympics
Excel Olympics
•
•
1.4K views 2 years ago







42:47
Now playing




USING THE DATA MODEL TO CREATE PIVOT TABLES: 1-HOUR TUTORIAL!

Simon Sez IT
Simon Sez IT

Verified
•
•
30K views 1 year ago









Show more








Saving your choice
An error occurred while saving your choice. Try again.

A Google company
en-GB

Afrikaans Azərbaycan Bahasa Indonesia Bahasa Malaysia Bosanski Català Čeština
Dansk Deutsch Eesti English (India) English (UK) English (US) Español (España)
Español (Latinoamérica) Español (US) Euskara Filipino Français Français (Canada)
Galego Hrvatski IsiZulu Íslenska Italiano Kiswahili Latviešu valoda Lietuvių
Magyar Nederlands Norsk O‘zbek Polski Português Português (Brasil) Română Shqip
Slovenčina Slovenščina Srpski Suomi Svenska Tiếng Việt Türkçe Беларуская
Български Кыргызча Қазақ Тілі Македонски Монгол Русский Српски Українська
Ελληνικά Հայերեն עברית اردو العربية فارسی नेपाली मराठी हिन्दी অসমীয়া বাংলা
ਪੰਜਾਬੀ ગુજરાતી ଓଡ଼ିଆ தமிழ் తెలుగు ಕನ್ನಡ മലയാളം සිංහල ภาษาไทย ລາວ ဗမာ ქართული
አማርኛ ខ្មែរ 中文 (简体) 中文 (繁體) 中文 (香港) 日本語 한국어
Sign in

Sign in


BEFORE YOU CONTINUE TO YOUTUBE


We use cookies and data to
 * Deliver and maintain Google services
 * Track outages and protect against spam, fraud and abuse
 * Measure audience engagement and site statistics to understand how our
   services are used and enhance the quality of those services
   

If you choose to 'Accept all', we will also use cookies and data to
 * Develop and improve new services
 * Deliver and measure the effectiveness of ads
 * Show personalised content, depending on your settings
 * Show personalised ads, depending on your settings
   

If you choose to 'Reject all', we will not use cookies for these additional
purposes.
Non-personalised content and ads are influenced by things like the content that
you’re currently viewing and your location (ad serving is based on general
location). Personalised content and ads can also include things like video
recommendations, a customised YouTube homepage and tailored ads based on past
activity, like the videos that you watch and the things that you search for on
YouTube. We also use cookies and data to tailor the experience to be
age-appropriate, if relevant.
Select 'More options' to see additional information, including details about
managing your privacy settings. You can also visit g.co/privacytools at any
time.
Reject all

Accept all

More options

Privacy Policy • Terms of Service