Forum Discussion

rahul_ferns's avatar
rahul_ferns
Helper II
5 years ago
Solved

Dynamic Calendar with Fixed Start Date and Dynamic End Date

Hi Experts I have found a calendar in this formun that I like, but want to make a change to the start date. I would like the start date fixed to 2019,1,1 and the end date dynamic like in the code (c...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Here you go.

    let
Source = List.Dates(StartDate, DurationDays, #duration(1, 0, 0, 0)),
StartDate = #date(2019,1,1),
EndDate = Date.From(Date.EndOfYear(Date.AddMonths(DateTime.LocalNow(),12))),
DurationDays = Duration.Days(EndDate - StartDate),
ToTable = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Renamed Columns" = Table.RenameColumns(ToTable,{{"Column1", "Date"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}})
in
#"Changed Type"

     

    Pat

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Here you go.

let
Source = List.Dates(StartDate, DurationDays, #duration(1, 0, 0, 0)),
StartDate = #date(2019,1,1),
EndDate = Date.From(Date.EndOfYear(Date.AddMonths(DateTime.LocalNow(),12))),
DurationDays = Duration.Days(EndDate - StartDate),
ToTable = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Renamed Columns" = Table.RenameColumns(ToTable,{{"Column1", "Date"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}})
in
#"Changed Type"

 

Pat

 

  • rahul_ferns's avatar
    rahul_ferns
    Helper II
    5 years ago

    Thanks, Pat

    Worked just as how I wanted

     

    Much appreciated