Error Encountere while using DATEADD function

[Mystery]

HI,

I am creating a calculated column using the DAX expression  DATEADD(bi_date[Date],-1,YEAR).

For a date key value =  07/01/1999 I see a blank in the calculated column,while for a date 07/01/2000 I get the desired o/p in the calculated column.

What could be the issue?

Regards

[v-frfei-msft]

Hi @Mystery,

How did you create your date table? As @themistoklis said,  Here you should create a date table to make all the necessary dates included in such as.

date = CALENDAR(date(1998,01,01),today())

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @Mystery,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

[themistoklis]

@Mystery

If in your dataset there are no data for Jan 1998 then the value will be shown as blank for 07/01/1999

For Jan 2000 you see the data because in your dataset you also have data for Jan 1999.

I hope it makes sense