Forum Discussion
kasife
Helper V
3 years agoConditional 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 sale" use the contract date + 1 month (insert the following month).
Thanks
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
2 Replies
- Ahmedx
Super User
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