Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
Solved! Go to Solution.
Hi @HeatherR
You may set the relationship between the two tables.Then create a measure like below.
Measure = AVERAGE(Table1[DAYS])
Regards,
Cherie
Hi @HeatherR
You may set the relationship between the two tables.Then create a measure like below.
Measure = AVERAGE(Table1[DAYS])
Regards,
Cherie
User | Count |
---|---|
132 | |
74 | |
70 | |
58 | |
54 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |