How to use Date.AddDays and Data.AddMonths together

[Anonymous]

Hi,

I have a date column where I would like to add +1 month and -15 days in Power Query. I can't add +15 days only because we have months with 31 days.

I try to use Date.AddDays([Date], -15), but if possible I would like to use Date.AddMonths in the same function.

Example:

date	new date
16/08/2020	01/09/2020

It's possible?

Thanks!

[camargos88 · Accepted solution]

@Anonymous ,

Try this one:

Date.AddDays(Date.AddMonths([Column1], 1), -15)

[Anonymous]

Of course hahah

thanks @camargos88