We'll start this chapter by looking at the group of DAX functions that deal with date and time. Starting with a brief description of each of the functions currently available in this group, we'll then turn our attention to some hands-on examples.
In the second half of this chapter, we'll be working with the time intelligence group of functions. Again, we'll start with a list of the functions in this group, before moving on to look at how these functions work with a date table in your data model to bring you new insights. We'll also work through some examples of using these functions to aggregate and compare data over different time periods.
This chapter will cover the following topics:
- Introduction to date and time functions
- Working with date and time functions
- Looking at time intelligence functions
- Making your...