topic Time in between Formula in Desktop

Time in between Formula

nataliesmiy1357 — Wed, 08 Jan 2025 17:19:57 GMT

Good afternoon!

I am looking to create a formula/measure to capture how much time is between each row/entry.

I have the AI_Start_Time and then AI_Norm_Time.

I need to make a formula that shows the difference in time between entry 1's AI_Norm_Time, and entry 2's AI_Start_Time

(ex: Time between 10/14/2023 6:35:54AM and 10/14/2023 6:46:36AM = 10 minutes and 42 seconds.)

Entry Number	AI_Start_Time	AI_Norm_Time
1	10/14/2023 6:35:52AM	10/14/2023 6:35:54AM
2	10/14/2023 6:46:36AM	10/14/2023 6:46:38AM

Re: Time in between Formula

mark_endicott — Wed, 08 Jan 2025 18:00:33 GMT

nataliesmiy1357 - it's not clear how you want to present this, but I've attached a PBIX file with a solution.

It shows the time in DD:HH:MM:SS format

If this works for you please accept as the solution. It helps others with the same challenge.

Re: Time in between Formula

Jihwan_Kim — Wed, 08 Jan 2025 17:54:02 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a new column.

OFFSET function (DAX) - DAX | Microsoft Learn

Difference in seconds CC = VAR _normtime = Data[AI_Norm_Time] VAR _nextrowstarttime = MAXX ( OFFSET ( 1, Data, ORDERBY ( Data[Entry Number], ASC ), , , MATCHBY ( Data[Entry Number] ) ), Data[AI_Start_Time] ) RETURN DATEDIFF ( _normtime, _nextrowstarttime, SECOND )

Re: Time in between Formula

mark_endicott — Fri, 10 Jan 2025 09:27:58 GMT

nataliesmiy1357 - Did either me or Jihwan_Kim solve this for you?

Accepting the solution helps other people find the answers on this forum, so please do this or let us know what else you need.