Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi all,
we just got Power BI at work hooray !!, I was trying to use it to do some employee timesheet calcs and I'm stuck, this seeems to have a huge community so i wondered if you could help 🙂
So
I want to find out what employee utilsation is -
I have two tables 1 dimension where instances of hours and thier activitiy are recorded and a fact table that contains employee details. the dimension table has an hours column where people enter either 3.7 for a half day or 7.4 for a full day, sometimes there are multiple entries for the same day.
I've had no problem adding a conditional column to the fact table based on the type of activity and can get a utilisation % by dividing the total hours by the chargeable hours, but should I be taking peoples FTE hours or ratio into account?, on the person key i have an FTE hours and a ratio column I could use.
Is there some dax that could do this complete calc - I'm intermediate level - unfortunately I cant share a file - but i have put some pictures
Hi @Anonymous,
What result do you want? Please list expected result, could you please give an example?
Best Regards,
Angelia
hi Angelia
I want to find a % utilsation figure but adjusted for FTE
I tried lots of measures but I think I'm missing something
I have a measure for total hours TOTHOURS = CALCULATE(SUM([POT[HOURS])
& one for chargeable time based on an additional column that marks activity 'chg' or 'nonchg'
CHGHOURS = CALCULATE(SUM([POT[HOURS]),
FILTER(POT,POT[CHG/NONCHG] = "CHG")
I get utilisation by dividing one by the other
what im unsure about is weather or not I should adjust for the fact that some people are part time, or is it enough that powerbi only sums the entries people make so an adjustment is not required.
if I should adjust is there some kind of nested function I could use
many thanks for your response
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |