Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table with different times for different technicians each day. I would like to calculate the total worked time per day per technician, per week, per month, and per year. What is the correct DAX formula for this? I already have several calculations. The total time per day per technician seems to be correct. However, when I try to display this in a matrix table per week or per month, it doesn't sum up the times. It keeps looking at the first time and the last time per period. Who has a suitable solution?
Example:
Solved! Go to Solution.
Does you column have a time data type?
Time data types have a maximum of 24hrs.
So if you add 23 + 2 = 1 and not 25!
And 8 + 8 + 8 + 8 + 8 = 16 and not 40.
Try using a decimal data type.
Does you column have a time data type?
Time data types have a maximum of 24hrs.
So if you add 23 + 2 = 1 and not 25!
And 8 + 8 + 8 + 8 + 8 = 16 and not 40.
Try using a decimal data type.
To find the first time of the day per technician:
To find the last time of the day per technician:
To find the total working time per day per technician:
Then the ‘Totale tijd min’ provides the total working time in minutes per day. When I place this as a value in a matrix table, I get an incorrect calculation of the total time. Also, when I try to see the total working time per week, I do not get accurate results.
I have a solution.
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
82 | |
55 | |
40 | |
20 | |
12 |