From the course: SQL Server Analysis Services

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

All about the date table

All about the date table - SQL Server Tutorial

From the course: SQL Server Analysis Services

Start my 1-month free trial Buy for my team

All about the date table

“

- [Instructor] There are a number of different ways you can create a Date Table, if you don't have one, like we do here. You can write one in SQL, create one in DAX, or download one from the internet. Your Date Table should describe a given date in lots of different ways. There are more things you might want to add in your calendar, including things like working days or holidays. To be a valid Date Table, it should contain this unique value, like we see here. Notice in this Date Table you have different parts of the date in different format, like month name, month number, day number of year and different representations for the values. So we even have fiscal year included within this Date Table. I'm going to click on Excel and take a look at some of the pivot tables in the model. Let's add the Total Sales measures that we created and the month name. Now, notice when you do this, the month of April is first, then August.…

Contents