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

    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 🙂

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

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
    4 years ago

    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.