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!

1 Reply

  • 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!