What is a Date Table / Calendar table in Power BI / Excel

What is a Date Table / Calendar table and why do you need one

Link to Free Download of our Power Query Calendar:

Link to SQLBI Article on Mark as Date Table

02:28 Turn off Auto Date Hierarchy
03:52: Copying a Power Query Calendar between Power BI Files
05:20 Changing the Start Date and End Date
07:15 Sorting Months and Days to display correctly
09:47 Changing the Financial Year End, Day of Week and Advanced Editor features
11:28 How the Calendar was built
13:46 Marking Calendar as Date Table
15:46: SQBI link
16:20 Total YTD
18:20 Copying a Calendar table into Excel

Follow me on LinkedIn

Twitter

Access Analytic Training

[scottymac]

Yet, another fantastic (and generous) offering. There are lots of Calendar (or Date) suggestions available from many great Power Query gurus (all deserving of the label), but what I particularly like about this one is that start and end dates are easy to define for a given effort, and each step is well documented -- so easy to customize. Very generous to include links to such amazing and well-written downloads. No matter what I learn from other videos I always learn something new here.

[neilthackeray]

Who needs Google translate when Wyn translates Geek to English! Thanks for taking the time to show us all that making complicated process is achievable, appreciated 😁

[dhanicole]

The trick that stood out for me was to use the "day of week" for your sort. What a great video!!

[ayandapeter]

I respect this guy, what a comprehensive explanation...definitely subscribing

[luda_c]

An excellent YouTube channel. Thank you very much! Great explanations.

[Adrian-pj]

You're great. Why aren't there teachers like that at school?
Great stuff 😊👍

[esthercraft]

Thank you so much this gotta be thebest offerings free o YouTube, no need to fuss anymore with date tables, you 😊

[Looii]

Thanks Wyn, I work for a company with a Financial Year end date of 30 June, so this is so beneficial for me!

[andrewsinha]

Thank you once again. This time for the free consultancy answering my question in the most though way. You even did it without me asking for it beautiful ! This is the best site for beginners to intermediate PBI newbies transferring from excel, and there are a lot on YouTube! Thanks again Andrew. Oh thanks for the link as well. I will use it and I'm sure I will watch this video again and again for all the little best practices and tips on keeping me out of trouble.

[brynorth]

I've done a three day course from Microsoft and multiple Linked In Learning classes on Power BI and none come as close to as thorough and well explained as yours. Thank you so much for putting this out there - you're a life saver!!!

[nathanwoolls]

This is very helpful, good to hear a Welsh accent as well!

[donaldstafford]

You are amazing. Thank you so much! It was incomprehensible to be how to understand how to forecast a project’s progress, and this has given me so many steps toward comprehending how all of this works.

[TurboJon]

Awesome! The most thorough explanation I've seen on the web. Thank you!

[SeelanRobert]

Great Tutorial, very clear explanation. Thanks Wyn
Thank you so much for including the Calendar Table download file.

[wayneedmondson]

Hi Wyn. Awesome tutorial and explanation! Thanks also for access to the Calendar Table file to copy and use.. much appreciated! Thumbs up!!

[GeertDelmulle]

Hi Wyn,
This was not (just) useful, … this was MASSIVELY useful (to put it mildly :-) !!
Even though it’s 20’, this is a crash course on the topic of Date/Calendar tables.
BTW: I like the prefix tricks of fTable and dTable, so, I call mine dCalendar and that gets rid of those ‘single quotes’ to make it even easier to use.
Thanks for sharing this most valuable chunk of knowledge.
Great job!! :-)

[hughgoble]

Hi, Wyn, thanks very much for this great resource and the explanations. It'll be a great help. I do financial modelling and financial year-end dates are often an issue. your calendar table will totally solve this problem.

[IvanCortinas_ES]

Thank you for the explanation. And for the Calendar-Table link.

[andreugeorge]

Thank you so much for this! SO incredibly helpful!

[AgulloBernat]

Hi Wyn! You can change the auto date time setting for the current file if you go to the data load section of current file further down on the left hand side of the options menu