DateDiff does not work

[Anonymous]

Dear All,

I need your help:

I want to calculate Delta Time between rows for each PackageCode based on Destination.

This code did not work. It gives me delta T 0 for some reason

= DATEDIFF(Query[Time], Query[Time], SECOND)

Separating Time from Date also did not help me

PBI

[amitchandak · Accepted solution]

@Anonymous , with Time or status change TS

Datediff(maxx(filter(Table,Query[Time] <earlier(Query[Time])),Query[Time]),Query[Time],second)

you may need

 && Query[source] = earlier(Query[source])

[Fowmy]

@Anonymous 

This is the DATEDIFF,

DATEDIFF(<start_date>, <end_date>, <interval>)

Your Start and End time are same,

= DATEDIFF(Query[Time], Query[Time], SECOND)

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn

[Anonymous]

Oh, I got it now:)

But when I want to to make difference between time and next in the row time, then how can specify it in <start_date>, <end_date>?