Forum Discussion
Date calculations fail for some date column
I have the following measure that works if I choose 'NC Main'[NC Completed Date] yet fails when I substitute 'NC Main'[NC Created Date]. The Created Date field just produces (BLANK). The two columns ...
Do you have a separate Calendar Table by a chance? If yes, by which date is it linked to your fact table?
rit_ty7
Advocate I
Advocate Il Would suggest to check for
- Nulls and blanks: Verify that the NC Created Date column does not contain any blank or null values, as this may cause the DATEDIFF function to return BLANK().
- Ensure NC Created Date and NC Completed Date are the same data type and format.