Calculating difference between 2 rows of data based on date and movement

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Difference measure: =
VAR _nextrowvalue =
    CALCULATE (
        SUM ( Data[Value] ),
        OFFSET (
            1,
            ALL ( Data ),
            ORDERBY ( Data[Date], ASC ),
            ,
            ,
            MATCHBY ( Data[Date] )
        )
    )
VAR _currentrowvalue =
    SUM ( Data[Value] )
VAR _currentrowtransaction =
    SUM ( Data[Transactions] )
RETURN
    IF (
        NOT ISBLANK ( _nextrowvalue ) && HASONEVALUE ( Data[Date] ),
        _nextrowvalue - ( _currentrowvalue + _currentrowtransaction )
    )

Hi SarahESkells ,

In addition to the solution provided by Jihwan_Kim, you can also produce the required output by writing calculated column like below:

Variance = 
VAR NextRow =
    CALCULATE (
        SUM ( [Value] ),
        FILTER ( 'Table', 'Table'[Date] = EARLIER ( 'Table'[Date] ) + 1 )
    )
VAR CurrentValue = 'Table'[Value]
VAR CurrentTransaction = 'Table'[Transactions]
RETURN
    IF ( NextRow = BLANK (), BLANK (), NextRow - CurrentValue - CurrentTransaction )

I attach an example pbix file.  

Best regards,

hi SarahESkells Please check the snapshot of the formula

if this solves your issue then please accept the same as the solution.