Substract datetime

[ukaufman]

Hi! I am trying to substract each row with the previous one at the same column. 

For example I need to substract the row 473 of "fecha_reporte_API" from the row 472 and so on. 

Is there any way of doing this?

Thanks! 

[Mariusz · Accepted solution]

Hi @ukaufman 

Please see the attached file with the solution, all you need to do is add an index column and later a custom column.

For reference please see Added Custom step on the attached 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[v-juanli-msft]

Hi @ukaufman 

You can create calculated columns in Data view easily.

Column = CALCULATE(LASTNONBLANK(Sheet3[fecha api],0),FILTER(Sheet3,Sheet3[fecha api]<EARLIER(Sheet3[fecha api])))

Column 2 = DATEDIFF([Column],[fecha api],SECOND)

Your  "fecha_reporte_API" repeats for many rows, what is your expected result for the same "fecha_reporte_API"?

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ddf