Fill dates between two dates

[Anonymous]

I have a employee table with  employee number,country, joined date and reasigned date as shown in the below image. There are employees from three countries.

I'm also maintaining the workingdays relavent to each country in the Date table in the boolean format

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. 

[vapid128]

Or you can do in dax.

Create Table:

Table 2 = GENERATE('Table',GENERATESERIES(int('Table'[DateStart]),INT('Table'[DateEnd])))

[vapid128]

Or you can do in dax.

Create Table:

Table 2 = GENERATE('Table',GENERATESERIES(int('Table'[DateStart]),INT('Table'[DateEnd])))

[Divergence_One]

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

[amitchandak]

@Anonymous , Refer to the file attached if that can help. Please refer the Table

[Anonymous]

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

[Anonymous]

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