Forum Discussion

sirros_iot's avatar
sirros_iot
Icon for Helper III rankHelper III
8 years ago

Difference 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...
Need Help
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
8 years ago

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_iot's avatar
sirros_iot
Icon for Helper III rankHelper III
8 years ago
Thank 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.
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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