available time
1 Topic
Available time for each worker
Hi all, I'm fairly new to Power BI and DAX, and I've already learnt alot from this community - thank you! I'm trying to create an overview of the time available for each worker in my department. The purpose of this is to quickly find a worker who has time for urgent cases. I have a data set with Worker ID, Task ID, Deadline of the task, and days it takes to perform the task. Furthermore I have calculated a temporary start and end date, and performed a check to see if any tasks overlap. What I want to do is calculate an adjusted start and end date so the tasks don't overlap without exceeding the deadline. I would also like to visualize this is in meaningful way so I can spot if a worker has available time for a urgent deadline. I have calculated my columns as follows: startDay: startday = [endDay] - [Days] endDay: endDay = [deadline] Overlap: Overlap = var __worker = [Worker ID] var __overlap = COUNTROWS( FILTER(ALL('data'); [Worker ID] = __worker && EARLIER(data[endDay]) > [startDay] && EARLIER('data'[endDay]) <= [endDay]) )-1 return IF( __overlap=-1; 0; __overlap ) The data set is available here: https://1drv.ms/x/s!AlGwu4CgVOGIhYc-8wFK5o4uj3e_Eg?e=crjUfG The pbix file is available here: https://1drv.ms/u/s!AlGwu4CgVOGIhYc9ip4krLoTuYolgg?e=GuTygg Thank you in advance.Solved3.4KViews0likes11Comments