In this section, we're going to look at some of the date and time functions in more detail by using them with some hands-on examples. We'll start by looking at a DAX expression to build a date table.
As we'll see in the Looking at time intelligence functions section of this chapter on time intelligence functions, we need at least one table in our data model that contains all the days for the years being analyzed for those functions to work correctly.
Unlike the date table we built in Chapter 3, Building Data Models where we built the table in sections using calculated columns, we'll build this date table with a single DAX expression.
