Forum Discussion

ElliotP's avatar
ElliotP
Icon for Post Prodigy rankPost Prodigy
9 years ago
Solved

Date Table, Powerquery to Future Set Date

Evening,   I've follow the guides to setup a Date Table using powerquery and it works perfectly.   let Source = #date(2010, 1, 1), Custom1 = List.Dates(Source, Number.From(DateTime.LocalN...
Need Help
Tutorial Requests
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Just replace DateTime.LocalNow() by #date(2018,1,1).

     

    Alternative code:

     

    let
    Source = Table.FromColumns({{Number.From(#date(2017,1,1))..Number.From(#date(2018,1,1))}}),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}})
in
    #"Changed Type"
MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

Just replace DateTime.LocalNow() by #date(2018,1,1).

 

Alternative code:

 

let
    Source = Table.FromColumns({{Number.From(#date(2017,1,1))..Number.From(#date(2018,1,1))}}),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}})
in
    #"Changed Type"