O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Last year and prior period values

One of the most common forms of comparison for a value is that of a base value to prior periods. The idea of a prior period generally takes either of the following two forms:

  • Comparison to a different period which relates to the current period—for example, comparison with the last month
  • Comparison to the same period with a year offset—for example, this month last year

Both forms of this calculation are conceptually the same—it is only the offset that is applied in the calculation that is different. Consider the situation of determining a value for the last month. Here, we perform a base calculation with a monthly offset from the current date. For the last year value, we perform the same base calculation with a 12-month ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required