Forum Discussion
Staff Utilization over multiple months
I'm a PBI newbie so there may be an easy solution to my utilization rate question but I'm totally stumped. I have three tables I'd like to use in my utilization calculation Resource Resource...
daxer-almighty
Solution Sage
Solution Sage
I have already told you why you get an error in your last formula.
In DIVIDE(Time[Total Billable Hours]/Time[Total Hours]) Time[Total Billable Hours]/Time[Total Hours] is just one number.
But I can't help you because your DAX is not readable. For instance, nobody can tell from your expressions if something is a column or a measure. Please read the guide to DAX formatting and stick to the rules religiously.