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.
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
Ah, perfect. Knew I was missing something obvious 🙂
Anne