Forum Discussion
Solved
Conditional column to increase 1 month after date
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...
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
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
