Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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.