iF ELSE statment with a calculation for a custom colum

[Anonymous]

Hello

Im trying to figure out how to get a colum to if else. 

I have a colum for completetion date of course and one with the number of years until retraining and I am trying to calculate the expiry date based on 

If completion date = null then "course has not started" else Date.AddYears([Completion Date],[Sheet1.Retraining])

I can currently just add the retraining colum to the completetion date and this gives me a result of the rows that have a completion date. But then I have error for all the ones that have Null instead. 

Anyone have any suggestions to achieve this. 

[Anonymous]

Worked perfectly, Thank you 🙂 

[Anonymous · Accepted solution]

Please check the error message. I reckon it is because of the Data type mismatch between the 2 results.

1. "course has not started" is text data type

2. Date.AddYears([Completion Date],[Sheet1.Retraining]) will have date datatype.

My suggestion is:

1. Create a new column "Actual Completion Date Text" with expression: Date.AddYears([Completion Date],[Sheet1.Retraining]). 

2. Convert this to Text data type.

3. Add conditional column "Completion Date"

If If completion date = null then (text value) "course has not started" else (column) "Actual Completion Date Text".

This will ensure you have same data type for both if else ouptut.