Forum Discussion
Chris123Terr
3 years agoFrequent Visitor
The DATEADD function returns wrong values.
Hello. I have a calendar table made with dax: calendar= Calendar(min(Date), max(Date)) The calendar starts on 07/04/1996 and ends on 06/11/1998 Now. I am using the function: ALL = Ca...
HotChilli
3 years agoCommunity Champion
What are the wrong values?
The key point that catches a lot of people is that DATEADD can only return dates which already exist in the date table.
As the date table you have is quite limited, I suspect this is what's happening
- Chris123Terr3 years agoFrequent Visitor
What do you mean by? "DATEADD can only return dates which already exist in the date table."
Thanks