Project Botticelli

Building a Date Table Purchase this course

25 November 2017 · 126 views

Mastering DAX Workshop

Almost all data models need to analyze data over time. The first step for handling date calculation is to create a Date table, which simplifies any date-related calculation. Because of its importance, you should be careful when you create a Date table.

In this module, you will see how to use functions such as CALENDAR and CALENDARAUTO to create a new date table in case your data source does not include one.

You will also see how to crete a Date table with the right metadata, marking the table as a Date table and applying the correct sort order to text columns containing day and month names. Finally, you will see considerations about handling multiple dates in the same table.

Log in or purchase access below to the premium version of this content.

Purchase This Course or Full Access Subscription

Single Course


Access this course for its lifetime*.
Subscription Best Value


Access all content on this site for 1 year.
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase

  • Redeem a prepaid code
  • Payment is instant and you will receive a tax invoice straight away.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.

* We guarantee each course to be available for at least 2 years from today, unless marked above with a date as a Course Retiring.

Online Courses