Forum Discussion

nolan0716's avatar
nolan0716
Regular Visitor
3 years ago

Not capturing values using dateadd

Hi,   So I was comparing the current value (Opportunity) and the value 3 months prior (PrevQuarterOPP) using the dateadd function but its not getting the correct value or should I say its not captu...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

nolan0716 , dateadd need continuous dates, so in case you need to add days, just add it to date

 

[Date] + 10

 

 

For month or year you can use Date function

 

Date(Year([Date]), Month([Date])+2 , Day([Date]) )

 

https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power-BI-Turning/ba-p/1187827

 

Dateadd and its Alternate: https://www.youtube.com/watch?v=9qiRivlBv8w&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=66