Calculating an average of hours worked for different 17-week periods

[Macaurly]

Hi all, 

I need to make a report which shows how many employees in a company worked an average of 47 hours per week in a given 17-week period.

I have currently managed to group my date column outside of Power Query into multiple 17-week periods (as in the first image), and would like to use this group in PowerQuery to then group by this colum (the button shown in the second image) so that my table shows all hours worked in this 17-week period. I could then calculate an average, however from what I can tell, I am unable to use this group in Power Query. Therefore, I am looking for an alternative to my problem. The third image is my table of data so far.

Thank

[rbalanci]

HI! kindly anyone can support me on how to convert the average hours correctly as it's exceeding 60 minutes in bi and not converting to hours like example, 96 minutes should be 1:36.

[v-qiuyu-msft · Accepted solution]

Hi @Macaurly,

In your scenario, you can create a measure based on the group like below: 

Measure = AVERAGEX(SUMMARIZE('Table1','Table1'[TimesheetDate (groups)],"Total",SUM('Table1'[TotalHours])),[Total])

Best Regards,
Qiuyun Yu 

[rbalanci]

Hi! Can you please support need your support how i can get correct average hours of below in power BI. example for instead of 1.99 minutes it  should apear as 2.39 or 2 hour and 39 minutes. i tried so many formula but not converting to hours after exceeding 60 minutes
.