Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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!
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!
User | Count |
---|---|
93 | |
87 | |
77 | |
72 | |
66 |
User | Count |
---|---|
115 | |
107 | |
86 | |
65 | |
64 |