Forum Discussion
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 use the PQ, so, no calculated columns. My data comes from a device( arduino).
This is my idea.
.Tempo concl = "Hole time in one execution request from a machine".
.TimeAll = AVERAGE from the time.
VAR X = IF (( [.Tempo concl.] )) > (2 * 'RealTimeData'[.TimeAll]);
"Suspended";"Working")
RETURN
VAR X
Any help, Thanks.
All my data
In the right I have timestamp
3 Replies
- MattAllington
Community Champion
2 things
i suggest you split date and time in different columns. This will make the workbook a lot smaller. You should do this match in the query editori stead of dax. Watch my video here https://m.youtube.com/watch?v=xN2IRXQ2CvI
sirros_iotThank 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/TimeRegards,
Xiaoxin Sheng
