Forum Discussion

Fab117's avatar
Fab117
Helper IV
2 years ago
Solved

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"

2 Replies

  • Hi Fab117 ,

     

    try like:

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

    • Fab117's avatar
      Fab117
      Helper IV

      This works perfectly.

       

      Big thanks.

       

      Fab