Prior-year comparison

The prior-year comparison sets a value against that of the same period of the previous year. In DAX, it is written with SAMEPERIODLASTYEAR or DATEADD in CALCULATE, on a continuous date table. The difference in value or percentage is then computed.

Example

Écart % = DIVIDE([CA] - [CA N-1], [CA N-1])

Related concepts

The whole glossary