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 st...
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
Greg_Deckler
Community Champion
Community Champion[To Date] - [From Date]
That will give you the number of days between the two dates.
Yes but in my report i need to create a date filter that date contains all date's. Here am expecting the date as one new column it contains all dates which have that from date and to date.
Regards,
Yuvaraj