Forum Discussion
HenrikH29
9 years agoAdvocate I
Problem calculation total work hours
I need to calculate the total work time per employee for a given period (ie month). Our employees have a normal work time calender with a daily work time ie 7.5 hours monday to thursday and 7 hou...
HenrikH29
9 years agoAdvocate I
Hi smoupre
Here's a mock up enclosed.https://www.dropbox.com/s/a1vn650ta4j0u3y/Eksempel%20til%20BI%20Community.pbix?dl=0
I have changed the fieldnames etc to english :-)
As you se I only get the value of total hours per week (97). Not the total value for all employees (196).
And another problem is, that it doesnt show the values per employee group but the same value for all groups.