Forum Discussion

kasife's avatar
kasife
Icon for Helper V rankHelper V
3 years ago
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 sale" use the contract date + 1 month (insert the following month).

 

 

Thanks