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))
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))