Arithmix Functions: SHIFTDIMENSION (shift a measure forward/backward along a dimension)

What is it?
SHIFTDIMENSION moves the source measure along the selected dimension. The most common use is a long a time dimension (e.g. take January’s measure value and move into February - shift forward by 1 month). SHIFTDIMENSION can apply to any dimension in the table and in combination with other functions.

How to write it?
Fx layout: = SHIFTDIMENSION(Table.Measure,Dimension1,number of shifts)

Example = SHIFTDIMENSION(Invoice value,Time.Month,2)
The invoice value from 2 months ago will result (e.g. to calculate payments of invoices 2 months from invoice month).