Year over year: comparing one period with its equivalent twelve months earlier, e.g. a YOY% calculation dividing the difference by last year's figure.
Also called year-over-year.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains YOY in context, with comparison tables and the common traps.
Terms in this definition
- OVER
Gives a T-SQL window function its window: PARTITION BY, ORDER BY and, if wanted, a ROWS or RANGE frame. Rankings and running totals can then be worked out while every row is kept.
- EARLIER
Within nested DAX row contexts, lets an inner calculation read a column as it stood in an outer pass; EARLIEST jumps to the outermost. Most people now use variables, which read more clearly.
- LAST
Restricted to visual calculations, this DAX function reads a value from the final position along one of the visual's axes. Writing INDEX(-1) gives the same result.