Multiple IF statements with multiple date columns

[Kaney1]

I am trying to create a single column to flag contract review status.  I want the query to first check the "Final Review Date" for a date and display as "Final Review Completed" if a date is entered.  If there is no date populated in the "Final Review Date" column, I want the query to check the "Initial Review Date" column for a date and display as "Initial Review Completed" if there is a date entered.  If neither date column displays a date, I want it to display "Not Reviewed".   I am not sure how to write all of these conditions in a single column.

Any help is greatly appreciated.

[Nathaniel_C · Accepted solution]

Hi @Kaney1 ,

Review =
IF (
    ISBLANK ( Dates[Final Review Date] ),
    IF (
        ISBLANK ( Dates[Initial Review Date] ),
        "Not Reviewed",
        "Initial Review Completed"
    ),
    "Final Review Completed"
)

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Nathaniel_C]

Hi @Kaney1 ,

Or you can do this in Power Query which is less drain on memory. Go to Power Query, Add Column tab, Custom Column.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel