O'Reilly logo

Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model by Alberto Ferrari Marco Russo and Chris Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8. Understanding Time Intelligence in DAX

Almost all data analyses have to deal with dates. DAX offers a number of functions that simplify many calculations on dates, but using the right function in the right way requires some explanation, starting from the requirements in data modeling.

In this chapter, you see how to correctly define a Date table in a Tabular model and how to handle more dates related to the same entity. Then, you learn how to implement common date-related calculations such as year-to-date, year-over-year, comparisons over years, and so on, including nonadditive measures.

Tabular Modeling with Date Table

As you have seen in examples in previous chapters, it is common to aggregate data by year and month by using columns ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required