Generate a list of dates incrementing by one year

[GlassShark1]

I've been trying to figure out something i'm sure is simple and it's taken me an embarassing amount of time!

All i want to to do generate a list of dates that increment a whole year each time (not 365 days!) when given:

1) A start date

2) An end date

3) The number of dates to produce

I thought i could do this with something like the below:

List.Dates(#date(2011, 03, 31), 10, #duration(365, 0, 0, 0))

However 365 days is different to a 'year', and all my dates must be "31/03/20XX", with the XX just incrementing by one year each time (31/03/2011, 31/03/2012, 31/03/2013 and so on)

Is there a simple way to do this?

I'll also need to produce a seperate list of the 5 earliest dates within that list too, and maybe remove dates that go beyond a certain threshold - but i'm new to M and struggling a bit so am taking baby steps!

Thanks 🙂

Thanks 🙂 

[mahoneypat · Accepted solution]

You can do it like this.  Start a blank query with this step.  You can adjust the initial list 0..9 and/or the start date in #date( ).

= List.Transform({0..9}, each Date.AddYears(#date(2020,1,1),_))

Regards,

Pat

[GlassShark1]

Excellent! Thanks 🙂

[amitchandak]

@GlassShark1 , Can Date.AddYears help?

https://docs.microsoft.com/en-us/powerquery-m/date-addyears

[GlassShark1]

I looked at that, but it seems to be for a single year - i couldn't get it to generate a list of years.