Target Workload

pocquet

Board Regular
Joined
Aug 21, 2013
Messages
118
Hello,

I am a bit new to power BI but not to report/dashboard creation.

I am currently working on a productivity dashboard for a team of 30 people.

I want to calculate their expected completion (so we can compare productivity)

I know that their target is 5 per hour and the data will be run twice per day once at mid day (5 hours into the day) and again the following morning (8 hours)

Simply mid day would be 5*5 to get the target however I am struggling to display it. All I want is a single line where we expect them to achieve. I want this to also work with a hierarchy if teams. Simply Team leader above their team.

Any ideas how I can achieve this?

Thanks

Jon
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Watch MrExcel Video

Forum statistics

Threads
1,102,369
Messages
5,486,448
Members
407,547
Latest member
Sankarasrinivas

This Week's Hot Topics

Top