Forum Discussion
Sum Hours with a Group By date in a Column/Measure
Hi all, I am trying to create a column/measure that takes a count of orders and divides it by the hours worked by an employee on a given day to get the average order per hour. In the query, I am ...
can you explain how did you get orders 100, 60 from the above table? what formula used for that?
Thanks
Raj
I just threw some numbers in there. Here is a table that matches the quantities in the raw data.
| Employee | Orders | Hours (WRONG) | Avg per Hour (WRONG) | Hours (Wanted) | Avg per Hour (WANTED) |
| James | 10 | 45.8 | 0.218340611 | 13.2 | 0.757576 |
| Sue | 10 | 41 | 0.243902439 | 21 | 0.47619 |
jfunderburk,
How do you get hours(13.2, 21) based on the sample data you post in the original post? When you create a measure using the DAX you post, you should get expected result.
Regards,
Lydia