Making your data more intelligent over time

In this section, we're going to look at some of the time intelligence functions in more detail by using them with some hands-on examples. As we mentioned in the previous section, you must have at least one date table in your data model for the functions in this group to work. If you don't have a date table in your data model already, make sure you add one, as outlined in the previous section on the date and time functions. This date table will also need to have a relationship with the SalesDateKey column in the Sales table.

DAX functions that return a single date

The first category of time intelligence functions that we are going to look at are those that return a single...