So I have two columns as stated in the picture above, where I have a date and worked hours, the date repeats since you don't usually work 8 hours in one thing only. What I need is to achieve this chart (image below) so for the bars it's okay, I've already calculated billable hours, but now I don't know how to calculate the % based on what should be a month time of work (160 hours w/o holidays) to create the lines. In excel I would just create a row that "=(A row with the monthly sum of hours)/160"
No, they are calculated differently, I already have a column that only mirrors the hours where there is a "yes" in billable, my problem is to create the line presented in that chart I've posted, I need to sum the hours monthly and divide by 160.
And it would be great if I can change this 160 when there's a holiday in the month to reflect it.
Yeah if you look at the table view there are 3 tables I've used. 1 is the Main table that had the Employee data, 1 is the Holiday table which exclusively has Dates and Holiday names. The last table is the calendar table where the hours per day are calculated.
So if you edit the "DayHours" column and change the 7 in the formula to an 8 it should give you what you need
It calculates as Mon-Fri is 8 hours unless theres a holiday on that day. Sat + Sun + Holidays = 0 hours
Yes, I've managed to do that, I'm really close but I don't know where is the last thing I'm missing, as you can see in the picture below, visual is identical but in one (the right one) it's showing 104% since that employee worked 4% more than 160 hours (w/o holidays) but in power bi it's showing 10.4% I don't know why!