Dynamic date table

[CarlsBerg999]

Hi,

I'm having issues with my datetable in PQ. I'm trying to create a date table for 30 days in the past and 30 days to the future, calculated from today. For example today is 9.2021, so the Date table would be from 9.1.2021- 9.3.2021 (always 60 days).

My code is like this: 

 Source = Number.From(DateTime.LocalNow ())+ 30 - Number.From(#date(2020,01,01)),
#"Converted to Table" = List.Dates(#date(2020,01,01),Source,#duration(1,0,0,0)),

I can't seem to fix the start date. This will end up with 1.1.2020 to today +30 days. 

Any ideas?

[Anonymous · Accepted solution]

let
    start = Date.From(Date.AddDays(DateTime.FixedLocalNow(),-30)),
    dates=List.Dates(start,60,#duration(1,0,0,0))
in
    dates