Forum Discussion
How to create a dates between from and to date
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
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]," , ")