Dynamic date - End of next year

[colgabusa]

Hello PBI community,

I'm trying to create a list of dates starting Jan 2017 to the end of next year, so far I created a list up to the end of present year but I could not find a way get the end of next year:

StartDate = #date(2017, 1, 1),
EndDate = Date.EndOfYear(DateTime.Date(DateTime.FixedLocalNow()))

Any ideas? 

[sturlaws · Accepted solution]

Hi @colgabusa ,

try this

Enddate = #date(Date.Year(DateTime.LocalNow())+1,12,31)

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.