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 th...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

     Date.AddMonths(DateTime.Date(DateTime.FixedLocalNow()),3)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

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