Forum Discussion
Time difference
Hello:
I want to get time difference in above dataset .Can some body help to solve this problem?
regards.
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.
8 Replies
mohsin-raza , create new columns like
datetime = [Dtum_aktiv-Copy.1] +[Dtum_aktiv-Copy.2]
diff =
[datetime] = maxx(filter(Table,[datetime] <[datetime]),[datetime])Iamitchandak thanks for reply . it is displaying empty column.
mohsin-raza ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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
