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

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.

No credit card required