M query - list.date from last year

Question

I am looking for an M query for the previous year's first day and the first month of the year till today's function.

the date starts with 2020-01-01, 2020-01-02, 2020,01-03.... 2021-08-17 and if it's tomorrow then refresh change it to 2021-08-18, 2021-08-19, etc...

then 2022-01-01 then the date should start with 2021-01-01, not 2020-01-01

Thanks in advance!

cnenfrnl · Accepted Answer

let
    today = Date.From(DateTime.LocalNow()),
    start = #date(Date.Year(today)-1,1,1),
    Source = List.Dates(start, Duration.Days(today - start)+1, #duration(1,0,0,0))
in
    Source

Forum Discussion

M query - list.date from last year

2 Replies

Related content

M Query - List.Dates(#date(2020,05,31), 365, #duration(1,0,0,0))

Power Query List.Dates with today function

List.Dates function- Count error

List.dates between dates in same column

merging direct query queries