Now that we've spent some time working with date and time functions in more detail, it's time to move on to looking at the time intelligence group of DAX functions.
The DAX language contains a number of functions related to time intelligence. This set of functions will enable you to get insight into your data by making it easy to perform analysis over different time periods. For example, you can get figures such as months, quarters, and year to date, or the same period last year. Each of these functions belongs to one of three categories:
- Functions that return a single date
- Functions that return a table of dates
- Functions that evaluate expressions over a period of time
In order to be able to use any of these time intelligence functions, your data model must contain at least one date table. This date table will also need to conform...