Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm trying to get see how many hours a month each employee has work on an specific project and what is that percentage of their working time by week and by month.
The data I obtain shows me how many hours the employee has worked in a project per week (week comencing), I have then calculated a percentage using 40h as 100%
When I create my reports, it shows correctly if columns display each week
However if I use date-hierarchy on the columns to show the values in percentage by months, It sums them all but it does not divide them by the number of weeks to get the % of the months
How could I resolve it?
Thanks
David
Hi,
Share the download link of the PBI file and clearly show the expected result.
Apologies as I don't know how to share the data or the PBI file
I have simplified it a bit to show what I want to achive.
On the left side, timesheets by hours, Right side by Percentages. Top graphs are by month and botton by weeks
I have issues with the percentage by month (top right table). I want it to create an montly avarage of the weekly percentaged, but my table sums them all together.
It should sum them together and divide it by the number of weeks. I type manually the results I would like to expect in the January column
Thanks
David
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |