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

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
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