cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
colgabusa
Regular Visitor

Dynamic date - End of next year

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? 

1 ACCEPTED SOLUTION
sturlaws
Resident Rockstar
Resident Rockstar

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. 

View solution in original post

1 REPLY 1
sturlaws
Resident Rockstar
Resident Rockstar

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. 

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!