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 a...
Need Help
  • FreemanZ's avatar
    FreemanZ
    2 years ago

    Hi Fab117 ，

     

    try like:

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

FreemanZ's avatar
FreemanZ
Super User
2 years ago

Hi Fab117 ，

 

try like:

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

Fab117's avatar
Fab117
Helper IV
2 years ago

This works perfectly.

 

Big thanks.

 

Fab