Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Complex Row Time Difference

Hi Team. Is there a way to reproduce this in Powerbi.?   This is the table I have to, in theory, I would like to subtract the time or duration between 2:36 PM and 2:50PM the same way I did in...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Can you do the same but with unsorted rows? I have the index but the timestamp is not in order. How can we achieve the same result?

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi Anonymous，

     

    The created Standard answer measure calculates the result of the current row. When the timestamp changes, the value will also change. And the order of calculation will be based on index column, you can observe "var st". In addition, you can refer to the Duration measure, even if it is an unsorted row, it will still be calculated based on the index.

     

    You can check the pbix file.

     

    Best regards,

    Henry

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for the help. Appreciate the time. m not getting the same results. Im sharing the code + the table 

      .Duration =
      var curindex = MAX('OMNI Hours Report'[Index])
      var nextstartime = CALCULATE(MIN('OMNI Hours Report'[Start Time]),FILTER(ALL('OMNI Hours Report'),'OMNI Hours Report'[Index]>=curindex+1))
      return DATEDIFF(MAX('OMNI Hours Report'[End Time]),nextstartime,SECOND)