topic Re: Find the difference between earliest and latest datetime in Developer

Find the difference between earliest and latest datetime

rebrow31 — Thu, 03 Feb 2022 11:54:11 GMT

Hi,

I have a table which holds data for every part that is produced. When a part is produced, it has a date time stamp (see below):

I have then easily created a visual which shows me the earliest and latest time a part was produced, see below:

How can I calculate the minutes between the earliest and latest shot datetime?

Re: Find the difference between earliest and latest datetime

lbendlin — Sat, 05 Feb 2022 00:59:25 GMT

([Latest DateTime]-[Earliest DateTime])*1440

Re: Find the difference between earliest and latest datetime

Anonymous — Mon, 07 Feb 2022 07:23:08 GMT

Hi @rebrow31 ,

I think you can try DATEDIFF function in your code.

Calculated column:

Column = VAR _SECOND = DATEDIFF('Table'[Earliest DateTime],'Table'[Latest DateTime],SECOND) RETURN DIVIDE(_SECOND,60)

Measure:

Measure = VAR _Summarize = SUMMARIZE('Table','Table'[Earliest DateTime],'Table'[Latest DateTime],"Minute", DIVIDE(DATEDIFF('Table'[Earliest DateTime],'Table'[Latest DateTime],SECOND),60)) RETURN SUMX(_Summarize,[Minute])

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.