Forum

Add a blank column ...
 
Notifications
Clear all

Add a blank column for actual values

3 Posts
2 Users
0 Reactions
161 Views
(@agwalsh)
Posts: 100
Estimable Member
Topic starter
 

I have set up a list of target hours by month for a list of employees. (This has been set up with formulas). I then pull it into Power Query and unpivot. So far so good. However I want to add a column to this query called Actual Hours where the user can enter the actual hours done each month. Then a utilisation formula that divides actual hours by target hours to give utilisation. 

I've set up the actual hours to be a separate column outside the query (see attached file) but is there a better way to do it rather than the way I have done it as I then want to be able to use all the data: actual hours and target hours and utilisation % in a pivot table. 

 
Posted : 06/12/2018 11:12 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Anne,

I'd put the Actual Hours for the user to input in a separate table and then merge that table with your Target Hours table. Then you can do the Utilisation calculation in PQ.

Mynda

 
Posted : 07/12/2018 12:48 am
(@agwalsh)
Posts: 100
Estimable Member
Topic starter
 

Ah, perfect. Knew I was missing something obvious 🙂

 

Anne

 
Posted : 07/12/2018 6:52 am
Share: