Average Time(Days) In location

[Tripb44]

I am needing a calculation to get the average time in location between rows in groups.  Below is the current data structure and desired output.

Data:

JOB	LOCATION	TIME
1	a	8/21/2021
1	b	8/22/2021
1	c	8/23/2021
1	d	8/24/2021
2	a	8/21/2021
2	b	8/22/2021
2	c	8/23/2021
2	d	8/24/2021

Output:

Location	Average Time(Days) In location
a
b
c
d

[v-angzheng-msft]

Hi, @Tripb44 

try to create a measure like this

_date = 
DATE(1899,12,30)+AVERAGE('Table'[TIME])

result:

Please refer to the attachment below for details. Hope this helps.

If I did not understand your question correctly, please consdier sharing more details about it.

Best Regards,
Community Support Team _ Zeon Zheng

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

[Greg_Deckler]

@Tripb44 Maybe:

Measure = 
  VAR __Table = ADDCOLUMNS(SUMMARIZE('Data',[LOCATION],[JOB],"__Max",MAX('Data'[TIME]),"__Min",MIN('Data'[TIME])),"__Duration",([__Max] - [__Min]) *1.)
RETURN
  AVERAGEX(__Table,[__Duration])