Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 ...
Need Help
  • AgataJ's avatar
    AgataJ
    1 year ago

    Do you have a separate Calendar Table by a chance? If yes, by which date is it linked to your fact table?

rit_ty7's avatar
rit_ty7
Icon for Advocate I rankAdvocate I
1 year ago

Anonymous Hello,
Maybe try the below code:

__TestAged =
VAR MaxDate = CALCULATE(MAX('datekey'[date]))
RETURN
IF(
[__TestStatus] = "open" &&
[__Test Created in RP] = "Valid" &&
NOT ISBLANK('NC Main'[NC Created Date]) &&
DATEDIFF('NC Main'[NC Created Date], MaxDate, DAY) > 60,
"aged",
"not aged"
)
where,
NOT ISBLANK('NC Main'[NC Created Date]): Prevents errors caused by blank dates