Set end date calendar to next 3 months

[Anonymous]

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.

[Vera_33 · Accepted solution]

Hi @Anonymous 

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