Forum Discussion

mohsin-raza's avatar
mohsin-raza
Icon for Helper III rankHelper III
4 years ago
Solved

Time difference

Hello:   I want to get time difference in above dataset .Can some body help to solve this problem?   regards.  
Need Help
  • mohsin-raza's avatar
    mohsin-raza
    4 years ago

    ryan_mayu  Thanks for reply. I like to get Time difference as i mentioned in my problem discription before. I solved it the concept of indexing like this way.

     

    Mean . How much  time the car takes traveling from Point1 to Pont2 and i got minutes now . There is some ambiguity in the result for exemple when car num change from 91 to 32,time difference is huge and it will solveble also and the expression i used is : 

     

    TIME = 'Table'[Date]-IF('Table'[Index]=0,'Table'[Date],LOOKUPVALUE('Table'[Date],'Table'[Index],'Table'[Index]-1))

     

    The problem is solved now.

    amitchandak  Thanks for your kind intiation in solving my problem.

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi mohsin-raza ,

 

Thank you very much for your feedback! If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry