Forum Discussion
Weighting Utilisation Hours by FTE decimal
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