Forum Discussion

barbaraferreira's avatar
barbaraferreira
Regular Visitor
3 years ago
Solved

DATEADD

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?  
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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!