Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Kaney1
New Member

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.  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.

1 ACCEPTED SOLUTION
Nathaniel_C
Super User
Super User

Hi @Kaney1 ,

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


reviewc.PNG

 


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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Nathaniel_C
Super User
Super User

Hi @Kaney1 ,

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


reviewc.PNG

 


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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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
custom column.PNG

 

custom column2.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.