Average Time between rows

[rodrigomocca]

Hello,

I've looking through the forum and I can't find the answer, so I'm asking my particular case.

I have a simple table with 2 columns: Name, ReportedDate.

I need to make a measurement with the average time (in hours) between all the rows. For example:

Test 1 - 01/22/2018 10:00:00 AM

Test 2 - 01/22/2018 10:30:00 AM

Test 3 - 01/22/2018 11:00:00 AM

With this data, I have a half hour on average.

How can I do this?

[Greg_Deckler · Accepted solution]

See this article:

https://www.linkedin.com/pulse/mean-time-between-failure-mtbf-power-bi-greg-deckler-microsoft-mvp-/?...

You will want the column that uses the EARLIER function. At that point you can create another column that calculates the difference in hours or minutes and then you should be good to go.

[rodrigomocca]

Thanks for your help.

I'm trying to reproduce it in my case.

I'm having another error with this part: DATEDIFF([ResolvedDate],NOW(),SECOND)

ResolvedDate column has this data.

ResolvedDate

1/22/2018 6:07:13 PM

1/22/2018 6:11:13 PM

1/23/2018 4:11:30 PM

1/22/2018 6:12:01 PM

1/22/2018 6:11:44 PM

and the error message is this: In DATEDIFF function, the start date cannot be greater than the end date. How this is possible?

[Greg_Deckler]

Yeah, DATEDIFF can be a pain:

DATEDIFF(NOW(),[ResolvedDate],SECOND)