Forum Discussion

MAJackson's avatar
MAJackson
Frequent Visitor
6 years ago
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...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    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.

JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

Something like this?

=DateTime.Date(#datetime(Date.Year(DateTime.FixedLocalNow())+1, 12,31)

Usually I create my data tables in DAX, not PowerQuery but this might be what you are looking for 🙂