From the course: SQL Server Analysis Services

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Challenge: Time intelligence measures

Challenge: Time intelligence measures - SQL Server Tutorial

From the course: SQL Server Analysis Services

Start my 1-month free trial Buy for my team

Challenge: Time intelligence measures

“

(bright music) - [Instructor] This challenge is much like the last one. We're going to write a few DAX measures and test them in Excel. First, we're going to open up the exercise files, select chapter four, go to the begin folder, open up the analysis services folder, and then select the SLN file to open up Visual Studio. We're going to be adding new DAX measures and not using the ones right now we created in the previous video. So this challenge is not dependent on the previous DAX challenge. And the first thing that we're going to want to do is mark the dimension date table as a date table using the extension tables. To do this, first select the tab containing dimension dates so that it has the focus. Next, go to the extensions menu at the top of the screen, select table, and then select date and mark as date table. The pop-up window will select the date value in the date table for you, then click OK. In our model, we…

Contents