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?
AgataJ
Helper II
Helper IIDo you have a separate Calendar Table by a chance? If yes, by which date is it linked to your fact table?
Yes, I have a date table 'DateKey' and 'nc main'[nc created date] is linked to 'datekey'[date]. there is a secondary link between [date] and [nc completed date].