Forum Discussion
Calculate employee utilization
I am pretty new to the scripting piece of PowerBI and need to solve the following problem: I track certain customer visits of my team using an XLS file. This file contains the date of the visit, the...
Now here comes the issue: There are weeks were an employee doesn't have a visit at all. And that breakes my calculation.
Here is what I have so far:
Measurement=((SUM(Responses[Duration [hrs]]])+Sum(Responses[Prep Time]))/Sum(WorkHrsIndividual[WrkHrsTotalIndividual])*100)
Hi BCMar,
Which result do you want to return if the employee doesn't have a visit at all? From the DAX, there should have two tables Responses and WorkHrsIndividual, please share some dummy data within these tables and clarify the corresponding expected results.
Best Regards,
QiuyunYu