Power Query Date Functions: Add a month to a existing dates to return the date of next month

[jjkh58]

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

[Ashish_Mathur]

Hi,

Please read this article - Date.AddMonths - PowerQuery M.

[TheoC · Accepted solution]

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 🙂

[jjkh58]

Thanks for your prompt help! @TheoC. I will for sure get in touch with you if I have any other questions. Appreciate for your help. Cheers.