Forum Discussion
IF/OR statement for a date
I'm struggling to get a IF(OR statement to work for evaluating if a column (formatted as Date) is blank or a date prior today. This is what I have:
NARD_Blank_Previous = IF(OR('Case'[Next_Action_Required_Date__c] = "", 'Case'[Next_Action_Required_Date__c] < TODAY()), "True", "False")
The error I'm getting is DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
ANy hints on how to make this work?
Anonymous try BLANK()
NARD_Blank_Previous = IF(OR('Case'[Next_Action_Required_Date__c] = BLANK(), 'Case'[Next_Action_Required_Date__c] < TODAY()), "True", "False")
