Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Set end date calendar to next 3 months

Hello,

I have a calendar table in Power Query with the end date dynamically calculated using the following step:

= Date.EndOfYear(DateTime.Date(DateTime.FixedLocalNow()))

But i want to change this expression to be always 3 months from today, so that means it should also go forward to the next year, for example, if today is 10 December 2022, then it should go forward 3 months into March 2023.

Is that possible? Any help is much appreciated.

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

     Date.AddMonths(DateTime.Date(DateTime.FixedLocalNow()),3)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

     Date.AddMonths(DateTime.Date(DateTime.FixedLocalNow()),3)