An Argument of Function Date has wrong data type or result is too small or too large

[yh90]

I'm calculating a year-over-year measure. The results are good, but sometimes the Matrix will not load and I get the error in the subject.

Here's what I have:

var _year = year(SELECTEDVALUE(Dates[week_end]))
var _month = month(SELECTEDVALUE(Dates[week_end]))
var _day = DAY(SELECTEDVALUE(Dates[week_end]))
var _this_year_date = date(_year,_month,_day)
var _last_year_date = date((_year - 1),_month,_day)

I've tried using DATEADD, but it doesn't work with DATE and SELECTEDVALUE (like my _this_year_date variable). I only have around 1.5M rows connected via Direct Query. Could it really be too big?

[Greg_Deckler]

@yh90 - It's likely too small of a value I would guess. SELECTEDVALUE returns blank if nothing is selected. You might try using it's optional parameter to return a default value if that is the case.