Forum Discussion
Solved
DateAdd does not work across year boundaries
Hi, I have found that I cannot use a DateAdd to find a date outside of the current year. Being the 31st Jan 2017 today, if I use (custom column) DATEADD('Data'[Today].[Date],-3,month) It ...
You need to create a Calendar table which contains the full calendar date if you want to use DATEADD Function.
This blog should also be helpful to you.
Best Regards,
Herbert
I do Agree. It is ridiculous.