Forum Discussion
Calculating actual work hours
Solution SupplierHi Rosenmeyer
This would be quite a complex statement to write if i understand your question correctly.
My approach would be a series of IF statements to check the time and date at which the case was created and the time and date at which the case was closed. You can use this to sum the full days in between (numbers of days * 10) and work out the hours on the start and end date.
My approach for the sat/sun days would be to link the table to a date table that has a column identifying a working day.
You can then use a filter to only sum those days where they are identified as a working day.
I hope this helps.
Thanks,
George
Thank you for your input, I appreciate it.
Yeah, I am quite new to Power BI and DAX, so it's not really in my capabilities yet, I was curious if there was an easier way to go about it. Maybe I'll have a go at fiddling about with some IF statements.
