cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mystery Regular Visitor
Regular Visitor

Error Encountere while using DATEADD function

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Error Encountere while using DATEADD function

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Highlighted
themistoklis New Contributor
New Contributor

Re: Error Encountere while using DATEADD function

@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

Community Support Team
Community Support Team

Re: Error Encountere while using DATEADD function

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Error Encountere while using DATEADD function

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.