topic Re: Fill dates between two dates in DAX Commands and Tips

Fill dates between two dates

Anonymous — Tue, 24 Nov 2020 10:48:47 GMT

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.

Re: Fill dates between two dates

Anonymous — Tue, 24 Nov 2020 11:37:44 GMT

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

Re: Fill dates between two dates

amitchandak — Tue, 24 Nov 2020 11:44:25 GMT

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

Re: Fill dates between two dates

Anonymous — Tue, 24 Nov 2020 12:30:55 GMT

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

Re: Fill dates between two dates

Divergence_One — Mon, 25 Jul 2022 17:09:01 GMT

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

Re: Fill dates between two dates

vapid128 — Mon, 25 Jul 2022 18:39:26 GMT

Or you can do in dax.

Create Table:

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

Re: Fill dates between two dates

vapid128 — Mon, 25 Jul 2022 18:39:35 GMT

Or you can do in dax.

Create Table:

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