Forum Discussion

jjkh58's avatar
jjkh58
Regular Visitor
4 years ago
Solved

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

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion

    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's avatar
      jjkh58
      Regular Visitor

      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.