Forum Discussion
Fab117
2 years agoHelper IV
Custom Column with If condition
Hi,
In Power Query, I've the table "InterimForEarliestDateCalculation(2)" which contains fields :
- "earliestStartDateCorrected" Date field
- "earliestStartDateCorrectedv2" Date field
I'd like to add a custom column (Text): "ErrorInMilestonesDates" which would comply with :
= "Correct" if "earliestStartDateCorrected" = "earliestStartDateCorrectedv2"
= "Incorrect" if "earliestStartDateCorrected" <> "earliestStartDateCorrectedv2"
Could someone help me with the code?
Thanks in advance
Fab
Hi Fab117 ,
try like:
= if [earliestStartDateCorrected] = [earliestStartDateCorrectedv2] then "Correct" else "Incorrect"