Forum Discussion
Unpivot data in Power Query based on Date range
Dear Experts, In my table I have StartDate and EndDate column. Based on this, Each row will be created for this date range. Please see the input and output table. Can you please help? ...
Hey dufoq3, you’re right. The final version will be:
List.Dates([Start date], Duration.Days([End date] - [Start date]), #duration(1, 0, 0, 0))
Anonymous, add a Custom Column with this formula and let me know if there is any problem:
List.Dates([Start date], Duration.Days([End date] - [Start date]) + 1, #duration(1, 0, 0, 0))Expand the new column to generate rows for each date.
Remove the original "Start date" and "End date" columns if not needed.
Hi, don't add +1 to Duration.Days --> based on example - he doesn't want to return dates till 14/08 but only to 13/08 for the first row.
Hey dufoq3, you’re right. The final version will be:
List.Dates([Start date], Duration.Days([End date] - [Start date]), #duration(1, 0, 0, 0))
