Error Message Help needed

[ArchStanton]

Hi,

I've inherited a Data Model that I'm trying to improve, however, I'm getting this error message in a measure which I'm struggling to understand let alone fix:

The measure is here:

YTD New Complaints =
TOTALYTD (
    COUNT ( 'Cases'[Case Number] ),
    'Cases'[tpo_applicationvalidationdate].[Date],
    "31/03"
)

I have recently built a new Financial Year Calendar in order to calculate YTD calculations but this tpo_applicationvalidationdate column contains blanks and has an inactive relationship with my calendar.

Created Calendar = 

VAR FYStartMonth = 4    --use 4, 7 or 10

VAR StartYear = YEAR(MIN('Cases'[Created On])) - 
        (MONTH(MIN('Cases'[Created On])) < FYStartMonth)

VAR EndYear = YEAR(MAX('Cases'[Created On])) +
        (MONTH(MAX('Cases'[Created On])) >= FYStartMonth)

VAR CalStart = DATE(2019, 4, 1)
VAR CalEnd = DATE(EndYear, FYStartMonth, 1) -1

RETURN ADDCOLUMNS(
    CALENDAR(CalStart, CalEnd),
    "Year", YEAR([Date]),
    "Qtr", QUARTER([Date]),
    "Month", MONTH([Date]),
    "MthName", FORMAT([Date], "MMM"),
    "FY", "FY" & YEAR([Date]) - (MONTH([Date]) < FYStartMonth) & "/" &
        YEAR([Date]) + (MONTH([Date]) >= FYStartMonth),
    "Financial Mth", MOD(MONTH([Date]) - FYStartMonth, 12) +1,
    "Financial Qtr", "FQ" & ROUNDUP(DIVIDE(MOD(MONTH([Date]) - FYStartMonth, 12) +1, 3), 0),
    "DayofWkName", FORMAT([Date], "ddd"),
    "DayofWkNumber", WEEKDAY([Date],2),
    "YearMthNum", (YEAR([Date]) * 100) + MONTH([Date]),
    "WorkingDays", NOT WEEKDAY([Date]) IN {1,7}
)

I cannot send a copy of the pbix file as its live data and the data model is huge so I'm hoping someone can point me in the right direction?

Thanks,

Ps I have a continuous range of dates in 'Create Calendar' [date] 

Thanks

[HotChilli · Accepted solution]

You are using your own Dates table and have probably switched off Auto date/time feature so references to .[Date] will not work.

Use the Date field you have created, put it in that measure

[ArchStanton]

Thanks, that was the reason!