Export (0) Print
Expand All
4 out of 6 rated this helpful - Rate this topic

Lesson 4: Mark as Date Table

SQL Server 2012

In Lesson 2: Add Data, you imported a dimension table named DimDate. You then renamed the DimDate table, in Lesson 3: Rename Columns, to simply, Date. While in your model this table is now named Date, it can also be known as a Date table, in that it contains date and time data.

Whenever you use Time Intelligence functions in calculations, as you will do when you create measures a little later, you must specify a Date table and a unique identifier Date column in that table. You can then create valid relationships between other tables and the Date table; necessary for calculations using DAX time intelligence functions.

In this lesson, you will mark the imported and renamed Date table as the Date table and the Date column (in the Date table) as the Date column (unique identifier). All the use of the name Date can get kind of confusing, but you’ll soon get the idea.

Estimated time to complete this lesson: 3 minutes

This topic is part of a tabular modeling tutorial, which should be completed in order. Before performing the tasks in this lesson, you should have completed the previous lesson: Lesson 3: Rename Columns.

To set Mark as Date Table

  1. In the model designer, click the Date table (tab).

  2. Click the Table menu, then click Date, and then click Mark as Date Table.

  3. In the Mark as Date Table dialog box, in the Date listbox, select the Date column as the unique identifier.

To continue this tutorial, go to the next lesson: Lesson 5: Create Relationships.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.