In this chapter, we started off by looking at the DAX date and time group of functions. We looked at how these functions can be used to create a custom date table in our data model, and how they can be used to find out date-related information, such as the number of days between two dates.
We then moved on to look at the time intelligence group of functions. We looked at the three different categories of function available in this group and how they can be used to help us gain further insight into the data held in our data model. We worked through a number of hands-on examples of these functions, using them to return single dates, tables of dates, and learning how to compare values over different time periods.
In the next chapter, we will continue our look at DAX functions by learning about the filter group of functions.