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.

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

mohsin-raza 

is this what you want?

Column = 
VAR _last=maxx(FILTER('Table','Table'[serienummer]=EARLIER('Table'[serienummer])&&'Table'[Datum]<EARLIER('Table'[Datum])),'Table'[Datum])
return DATEDIFF(_last,'Table'[Datum],SECOND)

mohsin-raza's avatar
mohsin-raza
Icon for Helper III rankHelper III
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.