I'm new to Power Bi and Power Pivot. I've been trying to search this community and found some diffrent solutuins but can't seem to get them to work.
I wanttocalculate the number of daysbetweentwo timestamps but exclude Saturday, Sunday andholidaysin the result. So these are incoming requeststoa ServiceDesk and then the response.
I got a calendar with holydays marked as 0 and working days marked as 1 so it looks like this:
We measure from thetimeparttothe nexttimepart as well as thedateif that makes any sense rather than just from one dayto00:00 the next day.
I'm also thinking we might trytocalculate it even more accurately because people allocate itemstosupport in the evening but it doesn't get looked at until we are operational the next working day. I might be really over complicating this though!
Would anyone have any idea if this is possible and if so howtoachieve this?
I need the measurement from Created day and time, to closed day and time, but without the holydays and time outside the business hour in ServiceDesk. The Business hour in Servicedesk is Monday to Friday from 07:00 to 17:00. (07:00AM to 05:00 PM)
Based on my understanding, you want to create number of days from CreatDate07:00 to ClosedDate17:00? Could you please post your sample data in table rather than picture, it's hard to reproduce your scenario if your data in picture. Thanks for understanding.