List of months

[Nick001]

hello,

Can you help me plz, I would like to generate a list in Power Query with all the beginning Days of the month from today 2 months in the past and 12 months in the future. Unfortunately I'm currently failing, maybe you have an idea?

Thx Nick

[Nick001]

Can you help me plz, I would like to generate a list in Power Query with all the beginning Days of the month from today 2 months in the past and 12 months in the future. Unfortunately I'm currently failing, maybe you have an idea?

Thx Nick

[Nick001]

wow, THX! That works! 

Thank you

Nick

[Jakinta · Accepted solution]

= let 
ThisMonth = Date.StartOfMonth( Date.From(DateTime.LocalNow())), 
Start = Date.AddMonths( ThisMonth,-2), 
End = Date.AddMonths(ThisMonth,12) 
in 
List.Select( List.Dates(Start, Duration.TotalDays(End-Start), #duration(1,0,0,0)), 
each _= Date.StartOfMonth(_))

or

= List.Transform( {-2..11}, each Date.AddMonths( Date.StartOfMonth( Date.From(DateTime.LocalNow())), _))