Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to create a dates between from and to date

Hi I have a From date and To date columns with in a table but i want remaining dates between from date - to date  for each and every employee id. Using calendar auto functions i have created date st...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous,

    Based on my test, you could refer to below steps in query editor:

    Sample data:

    Selected the two columns and use the "Unpivot columns" function:

    Now you could get the merged columns.

     

    Regards,

    Daniel He

chotu27's avatar
chotu27
Post Patron
7 years ago

Anonymous 

 

1. Click “Edit queries” to open Power Query editor

2. Make sure your date columns are date (not date/time) format

3.  Create a custom column

4. Listofdays = { Number.From([From Date])..Number.From([ToDate])}

5. Click OK

6. Click the “diverging-arrow” icon next to “Date” and click “Expand to new rows”. Notice the addition of new rows.

7. Change the column type to “Date”

8.  Click “Close and Apply”

 

 

Final Step Create Calculated

List of days = CONCATENATEX(FILTER(ALL(Tab),Table[Emplyee ID]=EARLIER([Emplyee ID])),[Listofdays]," , ")