Comparing equivalent periods

We've already looked at some of the time intelligence functions that are available in the DAX language. However, in this section, we are going look at how these—and other—functions can be applied to create a range of date and time patterns.

Comparing previous periods

For the first set of date patterns, we are going to look at some DAX expressions to create measures that will compare values over equivalent periods. The first of these will give the total sales quantity for the same period of the previous year.

The following expression will create a measure called Sales Quantity PY that will give the total sales quantity for the equivalent date in the previous year:

Sales Quantity...