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?
AgataJfollowing your thought process I checked my relationships. Interestingly enough if I make the active connection inactive the measures work. I'm still not sure why this should create such chaos but at least I have a 'fix' for now.
Thankyou
AgataJ
Helper II
Helper IIHi Anonymous ,
I'm glad you fixed the issue, and I am confused a bit as well. It's quite tricky to use two dates in one DAX measurement. USERRELATIONSHIP might be useful for inactive relationship.
Kind regards,
Agata