Home > OLAP Calculation Templates > Prior and Future Periods > Difference from Prior Period
![]() Previous |
![]() Next |
Returns the difference between the current value and the value of an earlier time period at the same level.
Difference from prior period for measure (...) in the time dimension and time hierarchy hierarchy number period ago.
This calculated measure compares the current value of Units with the value of the previous period.
Difference from prior period for UNITS(...) in the TIME dimension and TIME.CALENDAR hierarchy 1 period ago.
The Change column shows the difference in Units between the current period and the previous period. A Prior Period calculation computes the Last Period column.
Time Level Units Last Period Change ------ -------------------- -------- ----------- ------- Q1.05 CALENDAR_QUARTER 143607 149528 -5921 Q2.05 CALENDAR_QUARTER 138096 143607 -5511 Q3.05 CALENDAR_QUARTER 138953 138096 857 Q4.05 CALENDAR_QUARTER 145062 138953 6109 Q1.06 CALENDAR_QUARTER 146819 145062 1757 Q2.06 CALENDAR_QUARTER 145233 146819 -1586 Q3.06 CALENDAR_QUARTER 143572 145233 -1661 Q4.06 CALENDAR_QUARTER 149305 143572 5733 2005 TOTAL 565718 587419 -21701 2006 TOTAL 584929 565718 19211