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()))
Go to Solution.
Hi @colgabusa ,
Enddate = #date(Date.Year(DateTime.LocalNow())+1,12,31)
Cheers,SturlaIf this post helps, then please consider Accepting it as the solution. Kudos are nice too.
View solution in original post
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!