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: _Mes anterior_Recuento usuarios = calculate (([_Recuento usuarios]), ...
amitchandak
Super User
Super UserIdoiaPerez , 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