Calculate % of hours worked base two different working schedual using a calculated table/measure
Hello Power BI community, I will need some help for this task. I have two working schedule, the first one include working on saturday for 8 hours whereas the second one only works for 5 hours on that day. I created a calculated column to have a full calendar (removing the sundays) and specify the number of hours per day : The total number of hours worked and the names are on a non calculated table. The objective is to calculate depending on the person the % of hours worked (filtred by the number of days) In short : I want to devide "number of hours worked" by "sum work hour normal/exception" depending on the person. Thank you for your time and help!
