AVERAGE DAYS IT TAKES OUR USERS TO BILL A FILE PER MONTH

[Anonymous]

I am trying to determine the average days it takes our employees to bill their files per month.  I have two data queries - the first shows the period billed YYYYMM, the user, it lists the files and then advises the number of days it took to bill the file.  The second query shows the Period and then the Corresponding Date.  My results need to show the average per user per month. 

PERIOD	FILE #	USER	DAYS
201901	432432	User A	0
201901	432433	User B	9
201901	432434	User C	25
201901	432435	User A	99
201901	432436	User B	34
201901	432437	User C	1
201901	432438	User A	4
201902	432439	User B	9
201902	432440	User C	11
201902	432441	User A	65
201902	432442	User B	20
201902	432443	User C	2
201902	432444	User A	15
201902	432445	User B	19
201902	432446	User C	0
201902	432447	User A	0
201902	432448	User B	22
201902	432449	User C	6
201902	432450	User A	6

Period	Month
201901	Tuesday, January 01, 2019
201902	Friday, February 01, 2019
201903	Friday, March 01, 2019
201904	Monday, April 01, 2019
201905	Wednesday, May 01, 2019
201906	Saturday, June 01, 2019
201907	Monday, July 01, 2019
201908	Thursday, August 01, 2019
201909	Sunday, September 01, 2019
201910	Tuesday, October 01, 2019
201911	Friday, November 01, 2019
201912	Sunday, December 01, 2019

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may set the relationship between the two tables.Then create a measure like below.

Measure = AVERAGE(Table1[DAYS])

Regards,

Cherie