Forum Discussion
DATEADD ERROR
Hola expertos,
¿Puede alguien ser capaz de guiarme cómo solucionar este problema, por favor?
Mi código DAX es este:
3 Replies
- amitchandak
Super User
IdoiaPerez , dateadd need continous dates, so it can error if they are not
to add days, simple add to date
[Date] +20
for year and month use date
add 10 month
date(year([Date]) , month([Date])+10, day([Date]) )
Dateadd and its Alternate: https://www.youtube.com/watch?v=9qiRivlBv8w&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=66
Date as Dateadd
https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power-BI-Turning/ba-p/1187827 
FreemanZhi IdoiaPerez
DATEADD is a Time Intelligence function. Always reference the date column from a qualified Date Table in Time Intelligence functions.
Hi IdoiaPerez
You can refer to the following links:
Solved: Dateadd - Microsoft Power BI Community
Solved: DATEADD DAX FUNCTION - Microsoft Power BI Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
