Generate days view by start and end date?

wll6568

Check the below sample.

let
  Source = Table.FromRecords({    
  [Project Name= "Project A", Start Date= "2016-09-01", End Date = "2016-09-04"],    
  [Project Name= "Project B", Start Date= "2016-09-02", End Date = "2016-09-05"],  
  [Project Name= "Project C", Start Date= "2016-09-03", End Date = "2016-09-06"]
  }),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Start Date", type date}, {"End Date", type date}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "JoinCol", each 1),
    Source2 = Table.FromList(List.Dates(#date(2016, 1, 1), 365, #duration(1, 0, 0, 0)), Splitter.SplitByNothing(), {"date"}, null, ExtraValues.Error),
    Table2 = Table.AddColumn(Source2, "JoinCol", each 1),
    #"Merged Queries" = Table.NestedJoin(#"Added Custom",{"JoinCol"},Table2,{"JoinCol"},"NewColumn",JoinKind.Inner),
    #"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"date"}, {"NewColumn.date"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded NewColumn",{"JoinCol"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [NewColumn.date] >= [Start Date] and [NewColumn.date] <= [End Date]),
    #"Duplicated Column" = Table.DuplicateColumn(#"Filtered Rows", "Project Name", "Project Name - Copy"),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Duplicated Column", {{"NewColumn.date", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(#"Duplicated Column", {{"NewColumn.date", type text}}, "en-US")[NewColumn.date]), "NewColumn.date", "Project Name"),
    #"Removed Columns1" = Table.RemoveColumns(#"Pivoted Column",{"Start Date", "End Date", "Project Name - Copy"})
in
    #"Removed Columns1"