Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to show in a visual that an employee worked a certain amount of hours on a given date; and also show if it was above or under capacity for the day.
I also am trying to show which employees are working over time and at what rate.
Here is a sample of my data
Date | Employee | Work Hours | Capacity by Day | Capacity by Week | Capacity by Month
1/1/18 John S 6 8 40 160
1/3/18 Mike M 13 8 40 160
2/3/18 Susie R 6 8 40 160
3/2/18 John S 8.5 8 40 160
Hi @Anonymous,
Can you mark the proper answer as a solution please?
Best Regards,
Dale
Hi @Anonymous,
Please check out the demo in the attachment.
I would suggest you make some changes.
1. Create a date table like below.
DateTable = ADDCOLUMNS ( CALENDAR ( DATE ( 2018, 1, 1 ), DATE ( 2018, 12, 31 ) ), "Week", WEEKNUM ( [Date], 2 ), "Month", MONTH ( [Date] ), "CapacityByDay", IF ( WEEKDAY ( [Date], 2 ) IN { 1, 2, 3, 4, 5 }, 8, 0 ) )
2. Create a measure.
Measure = sum('Table1'[Work Hours]) - sum(DateTable[CapacityByDay])
3. Create a Matrix visual. You can drill down to see different results.
Best Regards,
Dale
Hi,
In a calculated column, you can write a simple Overtime formula
=MAX([Work hours]-[Capacity by day],0)
Hope this helps.
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |