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 ...
Get Practical PowerPivot & DAX Formulas for Excel 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
