Next day after timestamp

[Jeffrey_VC]

Hi everyone,

I looking for a solution where I have 2 timestamp and will calculate the differents between them.

When i calculate the differents I get a negative value if the first timestamp is later than the second one, like this.
Travel time is differents in minutes.

I need the value 1350 (minutes)
How can I solved this?

[ValtteriN]

Hi,

I assume that if the timestamp is lower we will assume it is on next day. Here is an example on how to build this:

Dax:

Column =

var _testNextDay =

IF('Table (31)'[time2]<'Table (31)'[time1],

DATEDIFF("00.00.00",'Table (31)'[time2],MINUTE)+720,

 DATEDIFF('Table (31)'[time1],[time2],MINUTE))

 return

 _testNextDay


End result:

If the time is lower we add 12 hours in minutes (720) and compare the second time to midnight. Otherwise we compare normally.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Jeffrey_VC]

Thank you @ValtteriN , this works! Thank you for your help.

[Jeffrey_VC]

Hi @ValtteriN ,
Thank you for your quick answer.
Your solution is not the solution that i need.

Time 1: 14:00
Time 2: 13:00

Different is 1350 minutes and not 1500 minutes so you have in your example.

[ValtteriN · Accepted solution]

Hi,

You are correct I had the wrong idea. This should work:

Column =

var _testNextDay =

IF('Table (31)'[time2]<'Table (31)'[time1],

((DATEDIFF("00.00.00",'Table (31)'[time2],MINUTE) -

DATEDIFF("00.00.00",'Table (31)'[time1],MINUTE))

/60

+24)*60

,

 DATEDIFF('Table (31)'[time1],[time2],MINUTE))

 return

 _testNextDay


Here we take the difference in hours = -1 hour then we compare that to 24 hours and multiply by 60. So here 23*60 = 1380