Forum Discussion

Kaney1's avatar
Kaney1
New Member
6 years ago
Solved

Multiple IF statements with multiple date columns

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....
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    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's avatar
Nathaniel_C
Community Champion
6 years ago

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's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    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