Unpivot a table with dates beetwen

Hi SebaSpotti ,

Make sure that your Start_Date and End_Date the data type was set to date in power query.

After that, you can add a new custom column using this M code:

List.Dates([Start_Date], Duration.Days([End_Date] - [Start_Date]) + 1, #duration(1,0,0,0))

Expand the Date List:

• Click the small icon with arrows at the top-right of the Date_List  column.
• Select Expand to New Rows. This will create a row for each date in the range.

Now your data look like this:

Rename the new column to Date.

Remove the original Start_Date and End_Date columns if they are no longer needed.

Your final result should look like this: