Creare a new table including working days between dates

Question

Hello Guys,&nbsp;&nbsp;I have this problem where there is a fact table with the a technician _id and the date that he started to work in this project and the date that he finished it.&nbsp; Something like that:&nbsp;&nbsp;project_idtechnician_iddate_opendate_close10001A12020-01-012020-01-1010002A12020-01-012020-01-2010003A22020-02-022020-02-2010004A32020-02-032020-02-20&nbsp;I'd like to count the number of distinct days that the technician has worked. It is a fact that the technician can work in several projects at the same time. Also, it counts all days between dates, incluing opening day and closing day.&nbsp;&nbsp;What is the best way to do that?&nbsp;Expected return:&nbsp;(technician_ID) - (work days)A1 - 20&nbsp;A2 - 19A3 - 18&nbsp;Thanks!&nbsp;&nbsp;&nbsp;&nbsp;

jihwan_kim · Accepted Answer

Hi,&nbsp;DDalmas&nbsp;Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.All measures are in the sample pbix file.&nbsp;&nbsp;&nbsp;https://www.dropbox.com/s/nuy2ru1w5wta2wv/ddalmas.pbix?dl=0&nbsp;&nbsp;&nbsp;Hi, My name is Jihwan Kim. If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.Linkedin: https://www.linkedin.com/in/jihwankim1975/

Forum Discussion

Creare a new table including working days between dates

2 Replies

project_id	technician_id	date_open	date_close
10001	A1	2020-01-01	2020-01-10
10002	A1	2020-01-01	2020-01-20
10003	A2	2020-02-02	2020-02-20
10004	A3	2020-02-03	2020-02-20