Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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.
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
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
.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |