Date Difference between snapshots based on a column

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

expected result measure: = 
VAR _seqone = -1
VAR _seqtwo = -2
VAR _dayone =
    MAXX(
        FILTER( data, data[snapshot_seq] = _seqone ),
        data[date]
    )
VAR _daytwo =
    MAXX(
        FILTER( data, data[snapshot_seq] = _seqtwo ),
        data[date]
    )
RETURN
    IF(
        HASONEVALUE( 'id'[id] ),
        DATEDIFF( _dayone, _daytwo, DAY )
    )

sam_gift If you want a calculated column in your table then you can try this:

Column = 
VAR CurrentSnapshotSeq = 
    Sam[SnapshotSeq]
VAR CurrentDate = 
    Sam[Date]
VAR PreviousDate = 
    CALCULATE ( 
        MIN ( Sam[Date] ),
        Sam[SnapshotSeq] > CurrentSnapshotSeq,
        ALLEXCEPT ( Sam, Sam[ID] )
    )
VAR Result = 
    IF ( 
        PreviousDate,
        INT ( CurrentDate - PreviousDate )
    )
RETURN Result

For a measure in a visual you can change it a little bit: