Power Query Add a new column that is One month greater than an existing field

[gheyman]

I have two feilds StartDate and EndDate. I want to Add a column that says if StartDate = EndDate then .....

My dates are always the first day of each month (1/1/2022, 3/1/2022......)

So if StartDate = 1/1/2022 and EndDate = 1/1/2022 how do I make the new column 2/1/2022? I cannot just add 30 days I need it to be the the first day of the next month.

Any help is appreciated

Again this is for Excel Power Query

 

[gheyman]

Found it

= Table.AddColumn(#"Reordered Columns1", "End Date", each if [StartDate] = [EndDate] then Date.AddMonths([EndDate],1) else [EndDate])

Thanks