Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Capacity Reporting with Employee Work Hours

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 want this visual to be used for the week...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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.

Capacity_Reporting_with_Employee_Work_Hours

 

 

Best Regards,

Dale