DATEADD

[barbaraferreira]

Hi guys, 

I'm having a issue with the DAX function DATEADD, I'm trying to compare some metrics week by week, did you guys know how to use function with the interval of week?

[Anonymous · Accepted solution]

Hi.

Please provide some more information of what your data looks like and what you want to achive.

Regarding the function DATEADD: make sure you use correct syntax, e.g.:

New_Date = DATEADD('Sales'[Order Date], 30, DAY)

You might also consider looking into Time Intelligence Functions in Dax:
https://learn.microsoft.com/en-us/dax/time-intelligence-functions-dax

Or combine Calculate (second argument filter context) and Previous Week to calculate a sum or similar previous week:

Sales WoW = CALCULATE(SUM([Sales Amount]), PREVIOUSWEEK(Calendar[Date]))

Hope this helps you on your way.

Kind regards!