Excluding blanks when determining if an item is submitted before a date

[jeffr6596]

I am working on a report and have run into a roadblock.  I would greatly appreciate assistance.

I have a table: Annualisp

I have a column: Date of Total Completion

I have a different column: Implementation Date

I am attempting to write a dax measure to calculate a "Yes" or "No" response if the Date of Total Completion was prior to the Imp Date.

I did that by writing 

Total Complete by Imp Date = IF(DATEVALUE([Date of Total Completion]) < [Implementation Date], "Yes", "No")

However, there are times when the Date of Total Completion field is blank.  With the above measure it counts all of those as "yes"

How do I write the measure in a way that will exclude all blank fields in the Date of Total Completion column?

Thanks 

[ToddChitt]

You can have nest IF statements in DAX. So maybe first check for a NULL value:

Total Complete by Imp Date = 

          IF ( ISBLANK ( [Date of Total Completion] ), "No", 

                 IF(DATEVALUE([Date of Total Completion]) < [Implementation Date], "Yes", "No"),

          )

[jeffr6596 · Accepted solution]

Thanks so much.  I changed the blank is no to blank is blank and in another measure counted the "yes" from the column.  Worked great for my purpose.