Forum Discussion
Castillo3CS
1 year agoFrequent Visitor
Calculating time between rows
Hi Team, We're having trouble calculating time elapsed for vehicles that are idling. Sensor data for each vehicle is being sent and we need to know how much time a vehicle (bus_id) has spent in i...
Castillo3CS
1 year agoFrequent Visitor
Error was me copying the values to the sample table. I'm testing your solution but PowerBi is taking a very long time to create the new column. We have over 1.4 million rows so I'm not surprised. Will let you know once it’s done.
Castillo3CS
1 year agoFrequent Visitor
Hi ryan_mayu , I had to terminate the process after 2 hours of "working on it", any ideas?
- ryan_mayu1 year agoSuper User
I don't have better solution for this. Maybe you can wait for longer time or let's see if anyone else have better solution for this.