Forum Discussion
sirros_iot
Helper III
Helper IIIDifference about time between consecutive time rows to use it as a variable
Hello all! First time here, sorry anything. I need to discover the difference in seconds about two consecutive rows and then combine it with an average of time in an especific id. OBS: I can't u...
sirros_iotHelper III
Helper IIIThank you for the answer. I will see what I can do, I can't use power query because I'm getting the data from the power BI online.
HI sirros_iot,
I'd like to suggest your to convert these time part to numeric(total second), then you can direct calculated on them. After calculation, you can transfer result to time format.
Reference link:
Aggregating Duration/Time
Regards,
Xiaoxin Sheng