Fill dates between two dates

Question

I have a employee table with&nbsp; employee number,country, joined date and reasigned date as shown in the below image. There are employees from three countries.&nbsp;I'm also maintaining the workingdays relavent to each country in the Date table in the boolean format&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;My requirement is to create a new table to fill the working days from the date of join and date of resign as one by one records on the table. *country also should be considered when filling the dates becuase correct workingday columns should be selected corresponsding to employees country.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

The requirements are not entirely clear. Could you please give an example of the output?

amitchandak · Answer

Anonymous , Refer to the file attached if that can help. Please refer the Table
&nbsp;

anonymous · Answer

This is the expected outcome. dates column depicts the workingdays between joined date and resigned date. Inorder to get the workingdays of the employee, date table has to be checked for the workingdays for each country. Availibility is just a column with 1 value to make the visulization easir on a matrix

divergence_one · Answer

Check-out these instructions to determine which of the two solutions will work best for you. Both solutions posted here are industry best.

vapid128 · Answer

&nbsp;&nbsp;&nbsp;&nbsp;Or you can do in dax.&nbsp;Create Table:Table 2 = GENERATE('Table',GENERATESERIES(int('Table'[DateStart]),INT('Table'[DateEnd])))