Turn Start Date & End Date columns into one column with

[pierre415]

Hey everyone,

I have 2 columns (Start Date and End date), each one specifying a different project, that I need to combine into one column containing all dates for each project. The column should include dates in between each project, eventually I'm creating a heat map calendar based off this. So far I have this for creating a new table:

Table 2 = CALENDAR( Table1[Start Date], Table1[End Date])

which is giving me 

"A single value for column 'Start Date' in Table1 cannot be determined" (I'd need to specify an aggregation)

Does anyone have an idea how to move forward from here?
Thanks,

Pierre

[v-shex-msft · Accepted solution]

Hi @pierre415,

You can follow below steps to use the query:

1. Click on 'fx' to add custom steps.

Previous step name:

2. Replace bold part with your column names and step name.

=Table.AddColumn(#"Changed Type", "Custom", each List.Dates([StartDate], Duration.TotalDays([EndDate]-[StartDate]), #duration(1, 0, 0, 0)))
                 previous step name                          startdate                       enddate   startdate

Regards,

Xiaoxin Sheng