Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Fill dates between two dates

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 working...
vapid128's avatar
vapid128
Icon for Solution Specialist rankSolution Specialist
4 years ago

 

 

 

 

Or you can do in dax.

 

Create Table:

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