UnitsInStockExtended:=CALCULATE( SUM(SnapshotTable[ValueToGet]), LASTNONBLANK ( SnapshotTable[Date], CALCULATE (SUM(SnapshotTable[ValueToGet])) ) )