Shift Data by one row down

Hi lightsaberluke 

Please try this:

Here's a sample:

Table:

Then add an index column in powerquery:

Next add a measure:

MEASURE =
VAR _currentIndex =
    MAX ( 'Table'[Index] )
VAR _previousIndex =
    CALCULATE (
        MAX ( 'Table'[Index] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Index] < _currentIndex )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Values] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Index] = _previousIndex )
    )

The result is as follow:

Or if you have an date column:

You can try this measure without an index column:

MEASURE 2 =
VAR _currentDate =
    MAX ( 'Table'[Date] )
VAR _PreviousDate =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Date] < _currentDate )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Values] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] = _PreviousDate )
    )

 The result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.