Forum Discussion
Solved
Dynamic End Date for Calendar Table
Hello, I am using a calendar table and would like to make the end date to be current year plus 1. I am using the following formula in the query editor: =Date.EndOfYear(DateTime.Date(DateTime.Fix...
Date.AddYears(Date.EndOfYear(DateTime.Date(DateTime.FixedLocalNow())),1)
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
I've found this method for creating a calendar table to be more flexible. A little bit longer to set up, but it can probably help you here.