Expand dates from first to last
Date Dates 01/03/2020 01/03/2020 03/03/2020 02/03/2020 07/03/2020 03/03/2020 15/03/2020 04/03/2020 27/03/2020 05/03/2020 06/03/2020 07/03/2020 08/03/2020 09/03/2020 10/03/2020 11/03/2020 12/03/2020 13/03/2020 14/03/2020 15/03/2020 16/03/2020 17/03/2020 18/03/2020 19/03/2020 20/03/2020 21/03/2020 22/03/2020 23/03/2020 24/03/2020 25/03/2020 26/03/2020 27/03/2020
Code:let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], L2T = Table.FromList({Number.From(List.First(Source[Date]))..Number.From(List.Last(Source[Date]))}, Splitter.SplitByNothing(), null, null, ExtraValues.Error), Type = Table.TransformColumnTypes(Table.RenameColumns(L2T,{{"Column1", "Dates"}}),{{"Dates", type date}}) in Type




Bookmarks