Conditional column to increase 1 month after date

[kasife]

Hi Guys,

How can I create a conditional column in power query using the following logic

If the sales confirmation column is equal to "confirmed sale" use the contract date column, if it is "open sale" use the contract date + 1 month (insert the following month).

Thanks

[Ahmedx · Accepted solution]

if [sales confirmation]="confirmed sale" then [Status change date] else Date.AddMonths([Status change date],1)

see attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhhXkS-4XM5wSlkaU?e=Fi5TR2

[kasife]

@Ahmedx Thanks so much. It worket perfectly.