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