Forum Discussion
Power Query Date Functions: Add a month to a existing dates to return the date of next month
Hi guys,
I have a column called "Payment Date". I need to create a new column that looks at each rows in "Payment Date" and return the date with next month.
e.g. 12/03/2021 >> 12/04/2021
02/04/2021 >> 02/05/2021
7/05/2021 >> 7/06/2021
Also, I would like to know how can I just return the next month with Text format.
e.g. if the payment date column had a date 12/03/2021, make the new column return "April"
15/04/2021 then the new column should return "May"
Thanks
Hi jjkh58
In Power Query, click on Custom Column and use below:
Date.AddMonths ( [Column Name] , 1 )Also in Power Query for the Month Name, click on date and then go to Add Column, click on Date, Month, Name of Month.
Done 🙂
3 Replies
- Ashish_Mathur
Super User
Hi,
Please read this article - Date.AddMonths - PowerQuery M.