How to calculate a monthly average, over several months?

[dcon]

Hi.

I have the following table of incidents and the length of time worked on each incident. I am looking to get teh average time worked per month over a period of months. For example, if i filter the page for Aug-Oct, i want to see the average time spent per month, over the three months. I.e. If total hours are Aug:14, Sept:55, Oct:27, then the average over the 3 months is 32.hours/month.

Any help appreciated!

Number	Created	Worked_Hours
INC1186400787	8/1/2018 6:31	0.25
INC1186401726	8/2/2018 8:47	0.17
INC1186401845	8/2/2018 12:30	0.67
INC1186401883	8/2/2018 13:26	0.92
INC1186403905	8/4/2018 21:21	0.33
INC1186403917	8/4/2018 21:56	0.00
INC1186403918	8/4/2018 21:56	0.00
INC1186403919	8/4/2018 21:56	0.00
INC1186405048	8/6/2018 10:51	0.17
INC1186405049	8/6/2018 10:51	0.17
INC1186405050	8/6/2018 10:51	0.17
INC1186405051	8/6/2018 10:51	0.17

[v-jiascu-msft]

Hi @dcon,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[LivioLanzo]

Hi @dcon

I create a calendar table and built the below:

and then i used:

=AVERAGEX(
    SUMMARIZE( 'Calendar', 'Calendar'[Month Name], 'Calendar'[Year] ),
    CALCULATE( SUM( WorkedHours[Worked_Hours] ) )
)

[dcon]

Thanks @LivioLanzo

I did the following:

- Created a calendar table, I think the columns are the same.

- Created relationship between Created in Table1 to Date in Calendar Table

- Created measure with your calculation below

The measure does not seem to return anything for me. Any ideas?

Regards,

donal

[Ashish_Mathur]

Hi,

Extract the Date from the created column by using =INT(Data[Created]).  Name this column as Date and build a relationship from this Date column to the Date column of the Calendar Table.