Custom Column with If condition

[Fab117]

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

[FreemanZ · Accepted solution]

Hi @Fab117 ，

try like:

= if [earliestStartDateCorrected] = [earliestStartDateCorrectedv2] then "Correct" else "Incorrect"

[Fab117]

This works perfectly.

Big thanks.

Fab