Forum Discussion
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 staticlly for all dates and also created data model connection but its not mapping as expected.
Regards,
Yuvaraj
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
7 Replies
chotu27Post Patron
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]," , ")
- Greg_Deckler
Community Champion
[To Date] - [From Date]
That will give you the number of days between the two dates.
v-danhe-msftMicrosoft Employee
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
