Incremented Data

[villasenorbritt]

I am dealing with data that deals with wood logs. Production is being tracked by incremented data. For example, between lines 9 and 10 you can see the data going from 536876724 to 53687644. This means that in that 30 seconds,  20 more peices of wood were produced or sent through that station in the mill. What I need is to find a way to bring this into Power Bi. Does anyone know a formula or a way to get production based off of this incremented data? Additionally, I will need to have selections for different intervals of time. I want to be able to select intervals and have power bi group the data accordingly. I'm completely lost on how to make this work or what formula would do the trick. Please help!

[ryan_mayu]

@villasenorbritt 

maybe you can try this

Column = 
VAR _last=maxx(FILTER('Table (2)','Table (2)'[date]<EARLIER('Table (2)'[date])),'Table (2)'[date])
return 'Table (2)'[data]-maxx(FILTER('Table (2)','Table (2)'[date]=_last),'Table (2)'[data])