O'Reilly logo

Practical PowerPivot & Dax Formulas For Excel® 2010 by Art Tennick

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 9Date & Time Functions 2/2: Time Intelligence Functions

This is the second chapter dealing with DAX Date & Time functions. The previous chapter discusses some of the basic Date and Time functions. In this chapter, the emphasis is on the time intelligence Date and Time functions. The time intelligence functions are primarily used to navigate dates. In particular, they allow you to jump ahead or back in time and retrieve relevant data. This is useful if you wish to compare your data across or between time periods. Practical applications would include year-on-year changes. They allow you to compare the present date, in your filter context, with past and future dates. In addition, these functions can help you define ranges of dates or dates ...

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